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

I have a sql table which looks like : srno | passportnumber|flightnumber Null ... Try this: ;WITH Ranked AS ( SELECT *, ROW_NUMBER() OVER(ORDER BY ...

stackoverflow.com