How do you sort in SQL? | SQL Server interview questions

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