Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use.

Correct Answer: Limit 10
Limit clause does not support partitioning, so we cannot get the top n within each partition without performing ranking; further, if more than one student gets the same GPA, it is possible that one is included in the top 10, while another is excluded.