O'Reilly logo
  • Dustin Waybright thinks this is interesting:

Filtering 1 percent gives you 8.3, and then the ceiling of this value gives you 9; hence, the query returns 9 rows.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Filtering by PERCENT rounds up to the next highest whole integer.