select * from (select *,row_number() over (order by [id]) '行数' from #a) as asd where b='2009-07-01'
sql获取当前数据为列表的第几行
最新推荐文章于 2022-10-18 15:48:47 发布
select * from (select *,row_number() over (order by [id]) '行数' from #a) as asd where b='2009-07-01'