Martin James

Martin James

  • NA
  • 100
  • 15.5k

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)