Q. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?

(A) “the ranking function “row_number” must have an order by clause.”
(B) “the ranking function “row_number” must have an over by clause.”
(C) “the ranking function “row_number” must have an partition by clause.”
(D) all of the mentioned

💬 Discuss

✅ Correct Answer: (A) “the ranking function “row_number” must have an order by clause.”

Explanation: order by clause is not optional clause in row number function.

Published by Mr. Dubey ⭐ 111.54K Points at 17-Sep-2023 08:16 am in Information Retrival Techniques

Explanation by: Mr. Dubey

order by clause is not optional clause in row number function.

💬 Discussion

📊 Question Analytics

👁️

348

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

86%

Success Rate