SELECT empid, lastname FROM HR.Employees
ORDER BY 1 DESC --order by first column
SELECT empid, lastname FROM HR.Employees
ORDER BY 2 DESC --order by second column
Order by index number in SQL
Lesson 10 of 97
Lesson 10 of 97
SELECT empid, lastname FROM HR.Employees
ORDER BY 1 DESC --order by first column
SELECT empid, lastname FROM HR.Employees
ORDER BY 2 DESC --order by second column