SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t(id INT);

INSERT INTO t VALUES (10),(30),(20),(5)
4 rows affected

SELECT *,ROW_NUMBER() OVER(ORDER BY 1)
FROM t
Msg 5308 Level 16 State 1 Line 1
Windowed functions, aggregates and NEXT VALUE FOR functions do not support integer indices as ORDER BY clause expressions.

SELECT *,ROW_NUMBER() OVER(ORDER BY NULL)
FROM t
Msg 5309 Level 16 State 1 Line 1
Windowed functions, aggregates and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions.

SELECT *,ROW_NUMBER() OVER(ORDER BY 1/0)
FROM t


id
(No column name)


10
1

30
2

20
3

5
4


SELECT *,ROW_NUMBER() OVER(ORDER BY @@SPID)
FROM t


id
(No column name)


10
1

30
2

20
3

5
4


SELECT *,ROW_NUMBER() OVER(ORDER BY DB_ID())
FROM t


id
(No column name)


10
1

30
2

20
3

5
4