Filtering 1 percent gives you 8.3, and then the ceiling of this value gives you 9; hence, the query returns 9 rows.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Filtering by PERCENT rounds up to the next highest whole integer.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/58327/