Ordering by SELECT index

Usually, you will order your SQL results by column name for example:

SELECT id, first_name, last_name
FROM users
ORDER BY last_name

but you can achive simillar result by replacing last_name by the index position in SELECT part of the query

SELECT id, first_name, last_name
FROM users
ORDER BY 3

NOTE: index starts with 1 instead of 0

Tweet