SQL号段整理

表A

1 125cf80b44b742f4a2e919db8b61a50123090117 0000000001
2 125cf80b44b742f4a2e919db8b61a50123090117 0000000002
3 125cf80b44b742f4a2e919db8b61a50123090117 0000000003
4 125cf80b44b742f4a2e919db8b61a50123090117 0000000005
5 125cf80b44b742f4a2e919db8b61a50123090117 0000000006
6 33a15ec46a3c4985942ce2db624f2db023040116 0000000001
7 33a15ec46a3c4985942ce2db624f2db023040116 0000000002
8 33a15ec46a3c4985942ce2db624f2db023040116 0000000003
9 33a15ec46a3c4985942ce2db624f2db023040116 0000000004
10 33a15ec46a3c4985942ce2db624f2db023040116 0000000005
11 33a15ec46a3c4985942ce2db624f2db023040116 0000000101
12 33a15ec46a3c4985942ce2db624f2db023040116 0000000108
13 41a1e8aeeff044e9b4bb203138a81e5900101 40015001
14 56939cac35db44538646406b1b39eec0230101 230201000000000001

执行的SQL:

select c.fbillid,c.fbillbatchcode,min(c.fbillno),max(c.fbillno) from 

(
 select  rank() over(order by c.fbillid,c.fbillbatchcode,c.fbillno) rowno,c.* from une_cbill c where c.FISINVOICE ='1'
order by c.fbillid,c.fbillbatchcode,c.fbillno
) c 
group by c.fbillid,c.fbillbatchcode,rowno-cast(c.fbillno as INT)

order by c.fbillid,c.fbillbatchcode,min(c.fbillno);

结果：

1 125cf80b44b742f4a2e919db8b61a501230901170000000001 0000000003
2 125cf80b44b742f4a2e919db8b61a50123090117 00000000050000000006
3 33a15ec46a3c4985942ce2db624f2db023040116 00000000010000000005
4 33a15ec46a3c4985942ce2db624f2db023040116 00000001010000000101
5 33a15ec46a3c4985942ce2db624f2db023040116 00000001080000000108
6 41a1e8aeeff044e9b4bb203138a81e5900101 4001500140015001
7 56939cac35db44538646406b1b39eec0230101 230201000000000001230201000000000030
8 56939cac35db44538646406b1b39eec0230101 230201000000001001230201000000001004
9 56939cac35db44538646406b1b39eec0230101 230201000000002001230201000000002039
10 56939cac35db44538646406b1b39eec0230101 230201000000002201230201000000002202
11 96acf9f7f3354721b1b08aaeea4d592c23070116 70111600017011160112
12 96acf9f7f3354721b1b08aaeea4d592c23070116 70111601257011160136
13 96acf9f7f3354721b1b08aaeea4d592c23070116 70111601477011160180
14 98e96a919a0a481d972f12759294df0f00102 1000030310000303