Menu
Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. Which of the following is the simplest ranking function ?
    2. A.
    RANK
    B.
    NTILE
    C.
    ROW_NUMBER
    D.
    None of the mentioned

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    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.

Write your comments here:

Be The First To Comment