jaypsan/RowNumberAsColumn.sql

Created December 13, 2022 13:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jaypsan/ac11b71c56ab867d19d88be49ad530a9.js"></script>
Save jaypsan/ac11b71c56ab867d19d88be49ad530a9 to your computer and use it in GitHub Desktop.

Download ZIP

SQLServer: add row number as a column during select

Raw

RowNumberAsColumn.sql

ROW_NUMBER() OVER (ORDER BY table.column)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment