What is the use of ORDER BY clause?

ORDER BY clause used to arrange the result set of query in ascending or descending order in order of single or multiple columns. ORDER BY clause is used in conjuction with SELECT statement.

SELECT <field name(s)>
FROM <table name>
WHERE <condition>
ORDER BY <field name> [ASC | DESC]

SELECT * FROM Employee
ORDER BY empname;

error: Content is protected !!