Sail E0 Webinar
Question
Which of the following is the simplest ranking function ?
Options:
A .  RANK
B .  NTILE
C .  ROW_NUMBER
D .  None of the mentioned
Answer: Option C


The ROW_NUMBER ranking function is the simplest of the ranking functions.Its purpose in life is to provide consecutive numbering of the rows in the result set by the order selected in the OVER clause for each partition specified in the OVER clause.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers