[Solved] Find the mistake in this query:SELECT ROW_NUMBER() OVER (ORDER BY) AS rn FROM orders; — Ans: ORDER BY clause is empty, must specify column(s) | SQL

SQL - Window Functions Fundamentals

Find the mistake in this query:

SELECT ROW_NUMBER() OVER (ORDER BY) AS rn FROM orders;

AROW_NUMBER() cannot be used without PARTITION BY

BORDER BY clause is empty, must specify column(s)

CMissing FROM clause

DROW_NUMBER() cannot be aliased as rn

Step-by-Step Solution

Solution:

Step 1: Check ORDER BY clause inside OVER()
ORDER BY must specify at least one column or expression to order rows.
Step 2: Identify error
Empty ORDER BY clause causes syntax error.
Final Answer:
ORDER BY clause is empty, must specify column(s) -> Option B
Quick Check:
ORDER BY inside ROW_NUMBER() cannot be empty [OK]

Quick Trick: ORDER BY inside ROW_NUMBER() must list columns [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this query: