Discussion :: SQL Server MCQs
- Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :
Whatsapp
Facebook
Answer : Option A
Explanation :
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.
Be The First To Comment