用sql语句根据操作顺序码生成表示号码范围的字段

col1      col2              col3
aaa        00000001       1
aaa        00000002       1
aaa        00000003       1
aaa        00000004       2
aaa        00000005       2
aaa        00000006       2
aaa        00000007       2 
bbb       00000008       3
bbb       00000009       3
bbb       00000010       3

--查询结果

aaa        00000001-00000003   1
aaa        00000004-00000007   2
bbb       00000008-00000010   3

--sql语句实现
SELECT OperateOrder, cpmc, lry, MIN(txm) + '------' + MAX(txm) AS txm,
      COUNT(txm) AS js, MAX(lrsj) AS lrsj
FROM V_ProductInfo
GROUP BY OperateOrder, cpmc, lry
ORDER BY OperateOrder DESC