ORDER BY Clause

It is used to sort data in ascending and descending order.

Emp_id	Emp_name
1	Suryagroops
2	Suresh
3	Mayank dixit
4	Suryagroops
5	Ramesh
6	Ramesh
7	Shalini
8	Sushil

                                                          (tbl_emp)                                                  
Default order is ascending order

SELECT Emp_Name FROM tbl_emp ORDER BY Emp_Name

SELECT Emp_Name FROM tbl_emp ORDER BY Emp_Name ASC

Result-

Emp_id	Emp_name
1	Mayank dixit
2	Ramesh
3	Ramesh
4	Shalini
5	Suresh
6	Sushil
7	Suryagroops
8	Suryagroops

Descending Order

SELECT Emp_Name FROM tbl_emp ORDER BY Emp_Name DESC

Result-

Emp_id	Emp_name
1	Suryagroops
2	Suryagroops
3	Sushil
4	Suresh
5	Shalini
6	Ramesh
7	Ramesh
8	Mayank dixit

Like

Emp_id	Emp_name
1	Suryagroops
2	Suresh
3	Mayank dixit
4	Suryagroops
5	Ramesh
6	Ramesh
7	Shalini
8	Sushil

Find all Emp_Name started from‘s’ in the table

SELECT        Emp_Name

FROM            tbl_emp

WHERE        (Emp_Name LIKE  ’s %');

Result-

Emp_Name

Suryagroops

Suresh

Suryagroops

Shalini

Sushil