O'Reilly logo
  • Bob Peplinski thinks this is interesting:

In the ORDER BY clause, you can alternatively reference a column by the column's position in the SELECT clause list rather than by name. Use an integer to indicate the column's position.


Cover of SAS Certification Prep Guide, 4th Edition


Why did no one tell me this about SQL: You can order using the column position integer. Shortens your code by a lot for long field names. Select company_code, employee_code from have order by 1,2;