sql server - How to generate serial number using sql query and ...

I have a sql table which looks like ... Try this: ;WITH Ranked AS ( SELECT *, ROW_NUMBER() OVER(ORDER BY passportnumber) row_num FROM Tablename ) ...

stackoverflow.com