Core Concept Mastery • DBMS Module
Imagine you are ordering a Pizza.
SELECT (Columns): You don't want the whole box, plastic, and receipt. You just want the "Slices" and "Toppings".
FROM (Table): You have to tell the waiter which kitchen to look in (The Italian Kitchen, not the Sushi Bar).
WHERE (Rows): You don't want every pizza. You only want the ones "Where Topping = Pepperoni".
ORDER BY (Sort): The waiter brings them out. Do you want the biggest pizza first? Or the hottest? Or the cheapest?
Data is useless if you can't find what you need. These commands let you ask smart questions like "Show me all high-scoring students, sorted by rank."
SELECT Name FROM Students WHERE Age > 18 ORDER BY Grade;
"Which clause is used to sort the result?"
ORDER BY.