Post

Martin James

NA
100
13.9k

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

Apr 20 2021 8:37 AM

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)

Difference between CONVERT and CAST

Data synchronization from one sql server to another sql server