求解楼主来点测试数据 看看 select a.* from t_hykbgjl a left join t_hykbgjl b on a.sJlbh=b.sJlbh+1 where b.nYe+a.nFse<>a.nYe
--sql 2000用子查询 SQL code: select m.* , n.* from ( select t.* , px = (select count(1) from t_hykbgjl where sKH = t.sKH and 记录号 < t.记录号) + 1 from t_hykbgjl t ) m, ( select t.* , px = (select count(1) from t_hykbgjl where sKH = t.sKH and 记录号 < t.记录号) + 1 from t_hykbgjl t ) n where m.sKH = n.sKH and n.px = m.px - 1 and m.nYe + n.nFse <> m.nYe
rs.open "select * from guide where city_name='北京' order by pai desc",conn,1,1 do while not rs.eof or rs.bof 。。 。。 。。 rs.movenext loop 这个sql语句在wap站里 本身有 ......
