SQL号段整理
来源:互联网 发布:java导入jar包 编辑:程序博客网 时间:2024/05/01 15:33
表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
- SQL号段整理
- undo段整理
- 手机号码段整理
- 实用代码段整理
- ORACLE 段的碎片整理
- SQL多字段排序
- SQL分时段统计
- sql 表字段编辑
- sql多字段排序
- SQL添加表字段
- SQL整理
- SQL整理
- SQL整理
- 整理SQL
- SQL整理
- sql整理
- SQL整理
- SQL整理
- java开发操作系统:进程间的消息通讯
- 获取手机的分辨率
- Excel-001 常用公式汇总
- (C++)函数参数传递中的一级指针和二级指针【【**】】
- iClient for JavaScript---客户端统计专题图
- SQL号段整理
- AFNetWorking --- README
- sz、rz命令的使用
- PageRank
- java打开文件
- Hadoop2.7.3+Spark2.1.0完全分布式集群搭建过程
- strtoul函数注意点
- Viewpager+Fragment+GridView 滑动切换时卡顿解决..
- 更新