With T-SQL, you can sort by ordinal positions of columns in the SELECT list, but it is considered a bad practice.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
4, 1 instead of the name for col4, col1, etc.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/57938/