ROW_NUMBER() OVER(ORDER BY [column name]) is what you want.
On Sep 4, 9:12 pm, san <[email protected]> wrote: > How can i get the row number in which record is stored in sql server. > > Example: suppose if record is stored in fifth row i want output as 5. > > Thanks!
