You can also specify a percent of rows to filter instead of a number. To do so, specify a FLOAT value in the range 0 through 100 in the parentheses, and the keyword PERCENT after the parentheses, as follows.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Top clauses don't have to be used with ORDER BY, but the outcome is unpredictable if not.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/58326/