select airline,
sum(saleprice) as saleprice,
sum(airporttax) as airporttax,
sum(oiltax) as oiltax,
sum(ticketnum) as ticketnum,
sum(voyagenum) as voyagenum,
(saleprice / s) as saleper
from tb_app_airlinesale_d
where data_date = '20130101'
and date_type = 't'
and ticketstatus = '0'
group by airline
union
select 'total',
sum(saleprice) as s,
sum(airporttax) as a,
sum(oiltax) as o,
sum(ticketnum) as t,
sum(voyagenum) as v,
'a'
from tb_app_airlinesale_d
where data_date = '20130101'
and date_type = 't'
and ticketstatus = '0'
group by 'total'
我想通过union新增一行合计,然后在新增一列,得到union上面的一个字段与下面对应字段的一个比值,用百分比显示
sum(saleprice) as saleprice,
sum(airporttax) as airporttax,
sum(oiltax) as oiltax,
sum(ticketnum) as ticketnum,
sum(voyagenum) as voyagenum,
(saleprice / s) as saleper
from tb_app_airlinesale_d
where data_date = '20130101'
and date_type = 't'
and ticketstatus = '0'
group by airline
union
select 'total',
sum(saleprice) as s,
sum(airporttax) as a,
sum(oiltax) as o,
sum(ticketnum) as t,
sum(voyagenum) as v,
'a'
from tb_app_airlinesale_d
where data_date = '20130101'
and date_type = 't'
and ticketstatus = '0'
group by 'total'
我想通过union新增一行合计,然后在新增一列,得到union上面的一个字段与下面对应字段的一个比值,用百分比显示
解决方案 »
- win7系统安装完 在使用中oracle11g蓝屏重启
- 怎样在isqlplus中将数据导出到excel
- 求个关于查询时间的SQL语句和做批量修改!!!!!
- 关于SQL SERVER 2005和ORACLE中的数据类型的差异
- ORA-12560问题,在线求解中......
- ORACLE启动服务就要300M内存,我十来个表,每个表几条数据,能不能让ORACLE启动服务少吃内存
- 一个问题
- Oracle 中建立自增序列的常用方法。
- 呼叫大虾!为什么在注册表修改日期格式不管用?
- oracle存储过程如何获取另外一个存储过程返回结果集的总行数
- 请问透明网关有谁用过,性能如何?
- 求助:临时变量如何实现下面的功能?
而百分比计算统计的话,可以用RATIO_TO_REPORT() OVER()分析函数。参考地址:
http://blog.csdn.net/rfb0204421/article/details/7676008
分析函数RATIO_TO_REPORT