Ordering Columns: single criterion

SQL: SELECT: Reporting

ASC is used to order results in ascending order. DESC is used to order results in descending order.

SELECT * FROM <table name> ORDER BY <column> [ASC|DESC];

Example:

SELECT * FROM books ORDER BY title ASC;
SELECT * FROM products WHERE name = "Sonic T-Shirt" ORDER BY stock_count DESC;
SELECT * FROM users ORDER BY signed_up_on DESC;
SELECT * FROM countries ORDER BY population DESC;