Question
Select ID, GPA from student grades order by GPA ____________
Inorder to give only 10 rank on the whole we should use :
Inorder to give only 10 rank on the whole we should use :
Answer: Option A
Was this answer helpful ?
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.
Was this answer helpful ?
Submit Solution