What actually happens when you run an SQL query?

What actually happens when you run an SQL query?

BackerLeader posted 1 min read

Do you know what actually happens when you run an SQL query?

It’s not as simple as: “SQL just fetches rows from a table.”

Behind the scenes, your query goes through a step-by-step execution order and knowing this is often an interview question for beginners.

Execution Order:

  1. FROM (pick the table)

  2. WHERE (filter rows)

  3. GROUP BY (make buckets)

  4. HAVING (filter buckets)

  5. SELECT (choose what to show)

  6. ORDER BY (sort the results)

  7. LIMIT (control how much to show)

Notice how WHERE comes before grouping, while HAVING comes after grouping.

Notice how ORDER BY is one of the last steps, even though we often write it after SELECT.

Common Confusions:

a) WHERE vs HAVING

  1. WHERE filters rows before grouping.

  2. HAVING filters groups after aggregation.

Example:

WHERE city = 'Delhi' → filter students from Delhi first.

HAVING COUNT(*) > 10 → only keep cities with more than 10 students.

b) GROUP BY vs ORDER BY

GROUP BY → bundles rows into categories (e.g., students per city).

ORDER BY → decides the sequence in which results are displayed (e.g., sort cities by student count).

c) LIMIT with ORDER BY

Important tasks like “find top 3 highest salaries” or “top 5 cheapest products.”

If you found this useful, drop a like or share it with someone preparing for SQL interviews.

Follow for more such insightful posts , I’m breaking SQL down into small, clear lessons you’ll actually remember.

If you read this far, tweet to the author to show them you care. Tweet a Thanks

More Posts

What is SQL? A Beginner's Complete Guide

Abdelhakim Baalla - Jul 10

Introduction to Subqueries, an advanced technique in SQL

gervais.amoah - Aug 14

How npm install Works? What Really Happens When You Hit Enter

PranavVerma - Jul 30

What Happens When You Type a URL Into Your Browser? (Interview Question Guide)

Khiilara - Jan 2

SQL vs NoSQL: Choosing the Right Database Before It Chooses Your Fate

Vignesh J - Aug 23
chevron_left