Rank Numbers in Original Insertion Order Without Using ORDER BY

[@MSSQLDBATechSupport]

create TABLE Numbers ( Value INT ); -- Insert the numbers in the specified order INSERT INTO Numbers (Value) VALUES (6); INSERT INTO Numbers (Value) VALUES (2); INSERT INTO Numbers (Value) VALUES (5); INSERT INTO Numbers (Value) VALUES (1); INSERT INTO Numbers (Value) VALUES (7); SELECT value, ROW_NUMBER() OVER (ORDER BY (select Null)) AS Rank FROM Numbers;

[@aniruddhabera6049]

Nice

[@MSSQLDBATechSupport]

Thanks