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

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

瀏覽:1377
日期:2025-04-29
I have a sql table which looks like ... Try this: ;WITH Ranked AS ( SELECT *, ROW_NUMBER() OVER(ORDER BY passportnumber) row_num FROM Tablename ) ......看更多