另开一贴 mysql查询段号的连续号码问题

[ecton]

SELECT min(b.spwyh) Start_HM, max(b.spwyh) End_HM
FROM
(SELECT a.*, CONVERT((substring(a.spwyh,8)-rownum),DECIMAL) cc FROM
(SELECT c.rownum,c.spwyh,c.xsj,c.xsinst,c.lbid FROM
(SELECT @rownum:=@rownum+1 as rownum,spwyh,xsj,xsinst,lbid FROM (SELECT @rownum:=0) r, spdetail ORDER BY lbid, spwyh) c where c.xsj=0 and c.xsinst=0) a ) b
GROUP BY b.lbid, b.cc
段号我已经实现了，哇哈哈哈，实现rownum，强身健体。！！！我太聪明了
可问题是我好想不要这个结果了，我要实现的是状态改变的。继续研究
给广大mysql研究人员一个结果！

[沟沟里的农民]

好样的！