Martin James

Martin James

  • 2k
  • 96
  • 3.1k

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

Apr 20 2021 8:37 AM
I have these two queries : 
 
  1. SELECT A,B, C FROM MyTable  
  2. ORDER BY 1,2  
  3.   
  4. ----------------  
  5.   
  6. SELECT A,B, C FROM MyTable  
  7. ORDER BY A,B  
What is the differences between them? 

Answers (2)