Use Both Order by Asc and Desc In Single SQL Query

Here is the use of both Order by ASC and Order by Desc in a single SQL query.

Several times we may have to use ORDER BY ASC and ORDER BY DESC in same SQL query on different columns. 

 

Here is an example of using ORDER BY DESC on one column.

 

SELECT * FROM mytable ORDER BY column1, column2 DESC

 

Here is an example of using ORDER BY ASC on one column.

 

SELECT * FROM mytable ORDER BY column1 ASC, column2.

 

Here is an example of using ORDER BY DESC and ORDER BY ASC on two different columns in a single SQL query.

 

SELECT * FROM tbl_Employee ORDER BY lastName ASC, Salary DESC

 

Here the lastname column is first sorted and after that salary shorted in desc.

 

Here is a free eBook, SQL Queries for Beginners