摘要：用的是数据库sqlserver2000,唉，有点老了，好处是到处都有，安装方便。 select ( select count(*) from temp_gzsphzb as t1 where spid <=t2.spid) as xh ,* from temp_gzsphzb as t2order 阅读全文