select sum(cargo_weight)
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200809'||'01','yyyymmdd') and last_day(to_date('200809'||'30','yyyymmdd')) and trans_eng='PVG')上面是09月的cargo_weight的总重量,我想要09月的减08月的总重量,语句应该怎么写呢?难道是
select sum(cargo_weight)
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200809'||'01','yyyymmdd') and last_day(to_date('200809'||'30','yyyymmdd')) and trans_eng='PVG')
-
select sum(cargo_weight)
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200808'||'01','yyyymmdd') and last_day(to_date('200808'||'30','yyyymmdd')) and trans_eng='PVG')
么。有简单的么?
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200809'||'01','yyyymmdd') and last_day(to_date('200809'||'30','yyyymmdd')) and trans_eng='PVG')上面是09月的cargo_weight的总重量,我想要09月的减08月的总重量,语句应该怎么写呢?难道是
select sum(cargo_weight)
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200809'||'01','yyyymmdd') and last_day(to_date('200809'||'30','yyyymmdd')) and trans_eng='PVG')
-
select sum(cargo_weight)
from (select * from cg_agg_transit_lgt t where flight_dt between to_date('200808'||'01','yyyymmdd') and last_day(to_date('200808'||'30','yyyymmdd')) and trans_eng='PVG')
么。有简单的么?
解决方案 »
- 表空间回收
- 为什么不能将数据库天加进服务器
- 有关datalink建立的问题。怎么查不能建datalink的原因呢。
- oracle 9i能安装在windows 2003上面吗?
- 请问我的电脑别人帮我装好了 oracle 本且可以运行。。能而昨天我重新启动了服务器。却不能访问数据库,请问我应该怎样做?
- 关于索引的迷惑!
- [SQL]组合查询的问题。
- to:bzszp(SongZip),再求一sql语句,谢谢!
- 学习中的迷茫
- 请 Luckysxn , penitent , zys2000 到此取分
- 为什么我用dba身份连接数据库就说,oracle还没有连接?
- SQL Server 2005 转到 Orcale数据库
from (select *
from cg_agg_transit_lgt t
where flight_dt between
to_date('200809' || '01', 'yyyymmdd') and
last_day(to_date('200809' || '30', 'yyyymmdd'))
and trans_eng = 'PVG') -
select sum(cargo_weight)
from (select *
from cg_agg_transit_lgt t
where flight_dt between
to_date('200808' || '01', 'yyyymmdd') and
last_day(to_date('200808' || '30', 'yyyymmdd'))
and trans_eng = 'PVG')
)
from dual
SUM ( CASE WHEN FLIGHT_DT>=TO_DATE ( '20080901' , 'YYYY-MM-DD' ) AND FLIGHT_DT<=LAST_DAY ( TO_DATE ( '20080901' , 'YYYY-MM-DD' ) ) , CARGO_WIGHT , 0 END ) -
SUM ( CASE WHEN FLIGHT_DT>=TO_DATE ( '20080801' , 'YYYY-MM-DD' ) AND FLIGHT_DT<=LAST_DAY ( TO_DATE ( '20080801' , 'YYYY-MM-DD' ) ) , CARGO_WIGHT , 0 END )
FROM
CG_AGG_TRANSIT_LGT
WHERE
TRANS_ENG='PVG'
SELECT SUM(CASE
WHEN TO_CHAR(FLIGHT_DT, 'YYYYMM') = '200809' THEN
CARGO_WEIGHT
ELSE
0
END) - SUM(CASE
WHEN TO_CHAR(FLIGHT_DT, 'YYYYMM') = '200808' THEN
CARGO_WEIGHT
ELSE
0
END)
FROM CG_AGG_TRANSIT_LGT T
WHERE TRANS_ENG = 'PVG';
SELECT SUM(DECODE(TO_CHAR(FLIGHT_DT, 'YYYYMM'), '200809', CARGO_WEIGHT, 0)) -
SUM(DECODE(TO_CHAR(FLIGHT_DT, 'YYYYMM'), '200808', CARGO_WEIGHT, 0))
FROM CG_AGG_TRANSIT_LGT T
WHERE TRANS_ENG = 'PVG';