Back to all posts
SQL

Order by index number in SQL

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…

Author

SQLDataDev Editorial Team

Mar 19, 2026 1 min read
SQL 
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

Topics covered

comma saparateIndexingmysqlOrder bySQL Serversql-serverSQL

Keep building your data skillset

Explore more SQL, Python, analytics, and engineering tutorials.

Browse All Posts