xxxxxxxxxx
//this_for_descending_order..
SELECT * FROM TableName ORDER BY columnName DESC;
// this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;
xxxxxxxxxx
SELECT * FROM table_name ORDER BY col1 ASC; -- ASCending is default
SELECT * FROM table_name ORDER BY col1 DESC; -- DESCending
SELECT * FROM table_name ORDER BY col1 DESC, col2; -- col1 DESC then col2 ASC
xxxxxxxxxx
-- SQL statements order
SELECT -> FROM -> WHERE -> GROUP BY -> HAVING -> ORDER BY -> LIMIT
xxxxxxxxxx
SELECT last_name, age
FROM Customers
WHERE NOT country = 'UK'
ORDER BY last_name DESC;
xxxxxxxxxx
Used to sort the result data in ascending (default) or descending order
through the use of ASC or DESC keywords.
Example: Returns countries in alphabetical order.
SELECT * FROM countries
ORDER BY name;
xxxxxxxxxx
select employee.name , employee.salary
from employee
order by employee.name;
--or
select employee.name ,employee.salary
from employee
order by 1 ;
-- 1 = represent the first column following the select clause
--last one ordered by other columns not in the select clause but existing in the table
--For example, the employee table contains the id, name, salary, and date_of_barth.
select employee.name , employee.salary
from employee
order by employee.date_of_barth;