Order by single and multiple columns in SQL

 Order by:

        ·       Order by can be used to order a column.

Order by with multiple columns:

·       Two of the same value in a column we have to order two columns.

v Order by column1 ASC/DESC , Order by Column2 ASC/DESC

v Separate the column names with comma’s

v Specify multiple columns and then order of them individually

v Can also use numbers

v ORDER BY 1, 2, 3

Example: 1

 Order by single column:

1. SELECT Ename, empno, hiredate, deptno

   From emp

   Order by  emp_id DESC;

Example: 2

 Order by multiple columns:

1. SELECT Ename, empno, hiredate, deptno

   From emp

   Order by hiredate ASC, emp_id ASC;

Example: 3

1. SELECT first_name, last_name, hiredate, deptno

   From employees

   Order by first_name , last_name;

Order of clauses:

1. SELECT clm_list

   FROM table_name

   WHERE <condition>

   GROUP BY clm_list

   HAVING <condition>

   ORDER BY clm_list;

Share: