Loading

What does ORDER BY 1, 2, ..., N in a query?

Martin James

5y1.1k

I have these two queries :

What is the differences between them?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi5y ago
Accepted answer
ORDER BY 1 is the ordinal number which stands for the column defined on the SELECT query.
It means ORDER BY A
I don't recommend using such a practice because if the column order changes, the query doesn't fail but you can have a different ordering from the one expecting.
+1
Aarti Gupta5y ago
order by A, B means first order by column A and then by column B, suppose Column A has employees' names and two employees has the same name then they will be arranged by column B like sur name or anything.

order By 1, 2 means the first arrange by the first column and then by the second column. they signify the ordinal positions of the column.
0