Question

The  __________ function that does not create gaps in the ordering.

(a) Intense_rank()

(b) Continue_rank()

(c) Default_rank()

(d) Dense_rank()

This question was posed to me at a job interview.

Question is taken from Recursive Queries and Aggregation Features in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct choice is (d) Dense_rank()

The best I can explain: 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.