티스토리 뷰

🌈 MsSql

row_number() without over

James Wetzel 2021. 7. 12. 15:30
728x90
반응형

SELECT

columName

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

FROM dbo.Transactions

 

참조 사이트

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

728x90
반응형