Note that even when you do have an ORDER BY clause, in order for the query to be completely deterministic, the ordering must be unique.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Versus using a column that has repetitive information, such as date.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/20404/