Multiple choice general knowledge science & technology

Which of the following is not a Oracle Analytical Function?

  1. ROW_NUMBER

  2. RANK

  3. ROWNUM

  4. FIRST_VALUE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ROWNUM is a pseudocolumn in Oracle that assigns a sequential number to each row retrieved, but it's not an analytical function. ROW_NUMBER, RANK, and FIRST_VALUE are all window/analytical functions that operate over sets of rows in a specific order.

Keep practicing — related questions