______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.
A. RANK
B. NTILE
C. DENSE_RANK
D. ROW_NUMBER
Answer:A
______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.
A. RANK B. NTILE C. DENSE_RANK D. ROW_NUMBER
Explanation: DENSE_RANK function makes the rank of a row is one plus the number of distinct ranks that come before the row in question.