📝 Question
#1142
The __________ function that does not create gaps in the ordering.
✓
Correct Answer
D. Dense_rank()
💡
Explanation
For dense_rank() the tuples with the second highest value all get rank 2, and tuples with the third highest value get rank 3, and so on. 5. SELECT ID, GPA FROM student grades ORDER BY GPA ____________; a) Limit 10 b) Upto 10 c) Only 10 d) Max 10 However, the 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.
⌨️ Press
A
B
C
D
to select