How do you sort in SQL?

Using the “ORDER BY” clause, you either sort the data in ascending manner or descending manner.

select * from sales.salesperson order by salespersonid asc

select * from sales.salesperson order by salespersonid desc