Q. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function? (Solved)
1. “the ranking function “row_number” must have an order by clause.”
2. “the ranking function “row_number” must have an over by clause.”
3. “the ranking function “row_number” must have an partition by clause.”
4. all of the mentioned
- a. “the ranking function “row_number” must have an order by clause.”