1.no=row_number() over(order by getdate()),
2.select (select count(1) from table_test b where b.unitName<=a.unitName) as i , a.* from table_test a;
1.no=row_number() over(order by getdate()),
2.select (select count(1) from table_test b where b.unitName<=a.unitName) as i , a.* from table_test a;