I have these two queries : SELECT A,B, C FROM MyTable ORDER BY 1,2 ---------------- SELECT A,B, C FROM MyTable ORDER BY A,B What is the differences between them?

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.

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.

Answers

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

Martin James

842

I have these two queries :

SELECT A,B, C FROM MyTable
ORDER BY 1,2
----------------
SELECT A,B, C FROM MyTable
ORDER BY A,B

What is the differences between them?

Answers (2)

Next Recommended Forum

Difference between CONVERT and CAST

Data synchronization from one sql server to another sql server

Leaderboard

View all

Rodrigo Diaz

Magnus Mårtensson

Tuhin Paul

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

186

13k

10.5k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

288.9k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Gowtham K

Aravind Govindaraj

Satya Karki

Vivek Kumar

Cr Bhargavi

Forum Statistics

Please welcome our newest member Paulo Dalla Nora Macedo.
3,077,224 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 5 new threads, 19 new posts, and 169 new users.
In last week, the most popular thread is 'Object reference not set to an instance of the Object.'.