创建的视图怎么添加第一项是自动编号

创建的视图如何添加第一项是自动编号

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;