📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    âš¡ Month End Offer - Flat 52% Off On All Courses! Enroll Now âš¡
    00:00:00 AM Left

    Question

    ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary

    DESC) assigns:
    A Same rank to ties Correct Answer Incorrect Answer
    B Unique sequential rank within each dept Correct Answer Incorrect Answer
    C Percentile of salary Correct Answer Incorrect Answer
    D Total salary per dept Correct Answer Incorrect Answer
    E Running total Correct Answer Incorrect Answer

    Solution

    ROW_NUMBER gives unique numbers ordered within partitions.

    Practice Next
    More SQL Questions
    ask-question