用的是数据库sqlserver2000,唉,有点老了,好处是到处都有,安装方便。
select ( select count(*) from temp_gzsphzb as t1 where spid <=t2.spid) as xh ,* from temp_gzsphzb as t2order by 1
留做纪念!
Powered by: 博客园 Copyright © 2024 alasunny Powered by .NET 8.0 on Kubernetes