Explanation:Example . rank() over (order by (GPA) desc). 4. The __________ function that does not create gaps in the ordering.
A. Intense_rank()
B. Continue_rank()
C. Default_rank()
D. Dense_rank()
Answer:A
Explanation:Example . rank() over (order by (GPA) desc). 4. The __________ function that does not create gaps in the ordering.
A. Intense_rank() B. Continue_rank() C. Default_rank() 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