In this chapter, you’ll learn how to sort your results in a specific order. In SQL, the data you select from a table is not guaranteed to be shown in a particular order. If you want to show it in a particular order, there is a command you can use.
Results Are Not Ordered
When you run a SELECT query
on a table, the data in the table is displayed for you to sees. If you run a SELECT query to get all rows, for example, you see all of the rows.
SELECT id, last_name, salary
FROM employee;
ID LAST_NAME SALARY
1 JONES 20000
2 SMITH 35000
3 KING 40000
4 SIMPSON 52000 ...
