Sorting Results

If you want the results of your query to appear in a specific order, you can use the ORDER BY clause

Select first_name, last_name
from employees
Order by last_name;

By default the SQL assumes Ascending order. You can make this more explicit by using the ASC or DESC keywords.

Select first_name, last_name
from employees
Order  by last_name Desc;

You can also order by multiple columns

Select first_name, last_name, gender
from employees
Order by gender Desc, last_name Asc;