总结: group by rollup(field1,field2); group by cube(field1,field2); group by grouping sets(field1,field2); 生成测试脚本： [c-sharp:nogutter:collapse:showcolumns] view plaincopyprint? ·········10········20········30
总结:
group by rollup(field1,field2);
group by cube(field1,field2);
group by grouping sets(field1,field2);
生成测试脚本：
[c-sharp:nogutter:collapse:showcolumns] view plaincopyprint?
·········10········20········30········40········50········60········70········80········90········100·······110·······120·······130·······140·······150
- SQL> CREATE TABLE Bill
- 2 (Bill_Month VARCHAR2(6),
- 3 Area_Code INTEGER,
- 4 Net_Type CHAR(1),
- 5 Local_Fare NUMBER(10,2))
插入测试数据：
[c-sharp:nogutter:collapse:showcolumns] view plaincopyprint?
·········10········20········30········40········50········60········70········80········90········100·······110·······120·······130·······140·······150
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5761,‘J’,5667089.85 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5762,‘G’,6315075.96 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5762,‘J’,6328716.15 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5763,‘G’,8861742.59 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5763,‘J’,7788036.32 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5764,‘G’,6028670.45 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5764,‘J’,6459121.49 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5765,‘G’,13156065.77);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200405’,5765,‘J’,11901671.70);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5761,‘G’,7614587.96 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5761,‘J’,5704343.05 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5762,‘G’,6556992.60 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5762,‘J’,6238068.05 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5763,‘G’,9130055.46 本文来源gaodai#ma#com搞@@代~&码网^);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5763,‘J’,7990460.25 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5764,‘G’,6387706.01 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5764,‘J’,6907481.66 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5765,‘G’,13562968.81);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200406’,5765,‘J’,12495492.50);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5761,‘G’,7987050.65 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5761,‘J’,5723215.28 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5762,‘G’,6833096.68 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5762,‘J’,6391201.44 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5763,‘G’,9410815.91 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5763,‘J’,8076677.41 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5764,‘G’,6456433.23 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5764,‘J’,6987660.53 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5765,‘G’,14000101.20);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200407’,5765,‘J’,12301780.20);
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5761,‘G’,8085170.84 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5761,‘J’,6050611.37 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5762,‘G’,6854584.22 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5762,‘J’,6521884.50 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5763,‘G’,9468707.65 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5763,‘J’,8460049.43 );
- insert into Bill (Bill_Month,Area_Code,Net_Type,Local_Fare) values(‘200408’,5764,‘G’,6587559.23 );
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：Oracle分析函数/聚合函数使用总结 .
转载请注明原文链接：Oracle分析函数/聚合函数使用总结 .
