Oracle动态查拆分号票，合并号段

 SELECT b.fdwnm,b.fpjdm,b.fpjzg,b.frksj,MIN(b.fpjh) FQSHM, MAX(b.fpjh) FQZHM  
FROM (SELECT a.*, TO_NUMBER(a.fpjh - ROWNUM) cc  FROM 
(SELECT * FROM dw_ff_temp t  ORDER BY fdwnm, fpjdm, fpjzg,fpjh) a) b 
 GROUP BY b.fdwnm,b.fpjdm, b.fpjzg,b.frksj,b.cc