Which of the following functions are similar ?
A. RANK and NTILE
B. RANK and DENSE_RANK
C. DENSE_RANK and NTILE
D. None of the mentioned
Answer:A
Which of the following functions are similar ?
A. RANK and NTILE B. RANK and DENSE_RANK C. DENSE_RANK and NTILE D. None of the mentioned
Explanation:DENSE_RANK() is same as RANK() function. Only difference is returns rank without gaps.