Which of the the function provides consecutive numbering except in the case of a tie ?
A. RANK
B. NTILE
C. ROW_NUMBER
D. None of the mentioned
Answer:A
Which of the the function provides consecutive numbering except in the case of a tie ?
A. RANK B. NTILE C. ROW_NUMBER D. None of the mentioned
Explanation:RANK function is used when you want all tied rows to have the same ranking.