Sorting Retrieved Data

Question 1

ORDER BY

Answer 1

(basically ascending – A to Z)-

SELECT prod_name
FROM Products
ORDER BY prod_name;

Question 2

ORDER BY 2 or more columns

Answer 2

SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY 2, 3;

Question 3

ORDER BY DESC (Z to A)

Answer 3

SELECT prod_name
FROM Products
ORDER BY prod_name DESC;

to apply DESC sorting to different column you must write DESC for every COLUMN

Question 4

ORDER BY multiple columns

Answer 4

SELECT prod_id, prod_price, prod_name
FROM Products
ORDER BY prod_price DESC, prod_name;