SELECT
ROW_NUMBER() OVER(ORDER BY (Select 0)) AS Row_Num, Employee_Name FROM MTB_Table_A
SELECT actid, tranid, val,
ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rownum
FROM dbo.Transactions;
reference:- https://www.mytecbits.com/microsoft/sql-server/row-number-without-using-order-by
https://stackoverflow.com/questions/44105691/row-number-without-order-by
No comments:
Post a Comment