Write a program or query to sort the list in SQL

 

In SQL Server Order By clause is used to sort records. the sort order is defaulted to ASC or ascending order. We can sort ASC or DESC in SQL server.

 

Example of sorting in Ascending

SELECT last_name
FROM tbl_EMP
WHERE employee_id > 500
ORDER BY last_name ASC;

 

Example of sorting in Descending  

SELECT last_name
FROM tbl_EMP
WHERE name = 'STK'
ORDER BY last_name DESC;