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