row_number() without over

SELECT

columName

, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rownum

FROM dbo.Transactions

 

참조 사이트

https://stackoverflow.com/questions/44105691/row-number-without-order-by