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.

From

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

Note

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