Day 10 of the @hertechtrail #HTTDataChallenge was to retrieve customer names in alphabetical order using SQL query. SELECT name (retrieves only the name column) FROM accounts (your customer names are in the accounts table) ORDER BY & ASC (sorts in ascending order ) #SQLQuery

I’m early today😂🤭 Day 9 of the @hertechtrail #HTTDataChallenge task is to retrieve all column from any specific table I used the commands SELECT * FROM region; Result = 4 rows and 2 columns SELECT * FROM accounts; Result = 351 rows and 7 columns #SQLQuery #SQLBasics

Hi Folks Which condition returns rows where manager_id is empty? . . #sql #sqlquery #dataanalyst #follow @bkarishma360 for me more....

SQL Basic Queries amzn.to/40qrsvX #sql #sqlquery #leransql #database

In the battle of wits with Oracle, who will emerge with the top 100 rows? 🤔🧙‍♂️ Source: devhubby.com/thread/how-to-… #TechTrends #SQLQuery #SQLDeveloper #Developer #row #oracle

Can I summon the Oracle to magically select distinct values, or should I just try waving my wand at the keyboard again? 🤔✨" Source: devhubby.com/thread/how-to-… #SQLQuery #SoftwareDevelopment #CloudComputing #Developer #values #oracle

Today, I learned in SQL how to: -->Create and drop databases. -->Create a table with PRIMARY KEY and NOT NULL constraints. -->Insert and select data from a table. -->Handle errors caused by inserting duplicate primary key values. #sqlquery #SQL

DataKliq SQL Challenge - Day 6! Which of the following is NOT an aggregate function? 🤔 Drop your answer in the comments! ⬇️ #DataKliq #SQLChallenge #SQLQuery

DataKliq SQL Challenge - Day 5! Ready to test your SQL skills? 🔍 Which SQL operator is used for pattern matching? 🤔 Drop your answer in the comments! ⬇️ #DataKliq #SQLChallenge #SQLQuery

Is count(2) just Oraclespeak for counting on one hand—and one foot? 🤔👣 Source: devhubby.com/thread/what-is… #DataSunday #SQLQuery #Oracle #DatabaseManagement #bethedifference #difference

How do I ask Oracle to convert timestamps to dates without it demanding a royal fee? 👑 Source: devhubby.com/thread/how-to-… #SQL #OracleTips #SQLQuery #TechTips #timestamp #columns

I was tasked with writing an SQL query to retrieve all columns from any of the tables. Below is a snippet of my query and the results👇 #SQLBasics #SQLQuery @hertechtrail @phaibooboo Stay tuned for Day 10 as I dive deeper into exploring this dataset and writing more queries!🚀

#day60 "📊 SQL Challenge: Find all workers with the letter 'a' in their first name! 🔍 #DataEngineering #SQLQuery #DataAnalysis #StrataScratch #100daysofcodechallenge

SQL Joins Cheatsheet #SQL #sqlquery Credit : sysxplore.com

Use EXISTS to check for related records based on conditions in another table. . . . #MySQL #SQLQuery #EXISTS #AdvancedSQL #DataFiltering

Un corto query de TSQL para darle mantenimiento a los registros transaccionales de una base de datos de SQL (logs maintenance). Te permite establecer el tamaño al que quieres reducir el archivo. #SQL #SQLQuery

Analyze order frequency! Use HAVING to filter groups based on aggregate results. . . . #MySQL #SQLQuery #GROUPBY #HAVING #IntermediateSQL

How does Oracle perform its CSI investigation on strings within strings? Source: devhubby.com/thread/how-to-… #oracle #codinglife #sqlquery #codingknowledge #search #oracle

Use LEFT JOIN to include all records from one table even if there's no match in the other. . . . #MySQL #SQLQuery #LEFTJOIN #TableJoins #IntermediateSQL

Have you tried convincing PostgreSQL that summing values is its true calling? Source: devhubby.com/thread/how-to-… #sqlquery #sqlserver #postgresql #databasetips