SQL Order By Clause

Order By clause is used to sorts the record in Ascending or Descending Order.

1) ORDER BY ASC:- It is used to sorts the record in ascending order.

SELECT * FROM table_name OREDR BY column_name ASC

Example:- Suppose we have employees table which has 7 records

+----+------------+-----------+----------------+------------+
| id | first_name | last_name | email          | address    |
+----+------------+-----------+----------------+------------+
|  1 | John       | Tailor    | john@abc.com   | California |
|  2 | Rom        | Tailor    | rom@abc.com    | California |
|  3 | Andrew     | Symonds   | andrew@abc.com | Sydney     |
|  4 | Miacle     | clerk     | miacle@abc.com | sydney     |
|  5 | Sachin     | Tendulkar | sachin@abc.com | Mumbai     |
|  6 | Virat      | Kohli     | virat@abc.com  | delhi      |
|  7 | rohit      | NULL      | rohit@abc.com  | NULL       |
+----+------------+-----------+----------------+------------+

Now, we want to get the record Order by first_name in ascending order

SELECT * FROM employees ORDER BY first_name ASC

Output:-


+----+------------+-----------+----------------+------------+
| id | first_name | last_name | email          | address    |
+----+------------+-----------+----------------+------------+
|  3 | Andrew     | Symonds   | andrew@abc.com | Sydney     |
|  1 | John       | Tailor    | john@abc.com   | California |
|  4 | Miacle     | clerk     | miacle@abc.com | sydney     |
|  7 | rohit      | NULL      | rohit@abc.com  | NULL       |
|  2 | Rom        | Tailor    | rom@abc.com    | California |
|  5 | Sachin     | Tendulkar | sachin@abc.com | Mumbai     |
|  6 | Virat      | Kohli     | virat@abc.com  | delhi      |
+----+------------+-----------+----------------+------------+


2) ORDER BY DESC:- It is used to sorts the record in descending order.

Syntax:-

SELECT * FROM table_name OREDR BY column_name DESC

Now, we want to get the record Order by first_name in descending order

SELECT * FROM employees ORDER BY first_name DESC

Output:-

+----+------------+-----------+----------------+------------+
| id | first_name | last_name | email          | address    |
+----+------------+-----------+----------------+------------+
|  6 | Virat      | Kohli     | virat@abc.com  | delhi      |
|  5 | Sachin     | Tendulkar | sachin@abc.com | Mumbai     |
|  2 | Rom        | Tailor    | rom@abc.com    | California |
|  7 | rohit      | NULL      | rohit@abc.com  | NULL       |
|  4 | Miacle     | clerk     | miacle@abc.com | sydney     |
|  1 | John       | Tailor    | john@abc.com   | California |
|  3 | Andrew     | Symonds   | andrew@abc.com | Sydney     |
+----+------------+-----------+----------------+------------+