Question

How to use ORDER BY in SQL

 

Answer 1

-- Ascending order

SELECT * FROM Workers
ORDER BY Salary ASC

-- ASC (ascending) is the order by default, We don't need to write the keyword ASC 

SELECT * FROM Workers
ORDER BY Salary 

 

70+ SQL courses for beginners and professionals

Answer 2

-- Descending order

SELECT * FROM Workers
ORDER BY Salary DESC

 

70+ SQL courses for beginners and professionals

Answer 3

-- Ascending order

SELECT * FROM Workers
ORDER BY Age, Salary

 

70+ SQL courses for beginners and professionals

Answer 4

-- Ascending and Descending order

SELECT * FROM Workers
ORDER BY Age ASC, Salary DESC

 

70+ SQL courses for beginners and professionals