- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
SELECT TOP (3) WITH TIES will cause any records with a repeating value in the ORDER BY statement to be brought in. For example, if the date is order by and 5 records have date 2009-01-01 you will get 5 and not 3.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/20405/