Master SELECT Now!

Source: Author

Not a medium member? Read here!

SQL is not only coding, it’s 100% spoken.

The best way to learn it is to express what you need in plain language. When you think in sentences, you’ll understand how to structure queries.

You need information about sales for a specific salesperson. You might say:

• “We need sales information for salesperson X.”

This translates directly to:

SELECT 
  * 
FROM sales_table 
WHERE salesperson = 'X';

Each part of the sentence maps to a clause in SQL:

• We need → SELECT
• Sales information → columns or *
• From sales_table → FROM
• For salesperson X → WHERE

SQL feels like natural language and simplify complex queries.

Structure of a SELECT

So, you’ve written the sentence. Now, you need to understand which statement can be used for each part of the statement.

SELECT 
  column1, column2, ...
FROM table_name
WHERE condition
GROUP BY column
HAVING condition
ORDER BY column ASC | DESC;

What each part means in plain language:

• SELECT: What information do you want?