tbale:a
(id,name)
ID NAME
1 AA
tbale:b(
id,
a_id,//表a的ID
a_date,//日期
times,//次数
type)//类型(有1和2)ID A_ID A_DATE TIMES TYPE
1 1 2007-1-31 33 1
2 1 2007-1-31 23 2
3 1 2007-1-30 65 1
4 1 2007-1-30 34 2
5 1 2007-1-29 32 1
6 1 2007-1-29 88 2根据A表的ID查询如下结果
ID NAME TYPE1_TODAY TYPE1_YESTERDAY TYPE2_TODAY TYPE2_YESERDAY TYPE1_SUM TYPE2_SUM
1 AA 33 65 23 34 130 145
(id,name)
ID NAME
1 AA
tbale:b(
id,
a_id,//表a的ID
a_date,//日期
times,//次数
type)//类型(有1和2)ID A_ID A_DATE TIMES TYPE
1 1 2007-1-31 33 1
2 1 2007-1-31 23 2
3 1 2007-1-30 65 1
4 1 2007-1-30 34 2
5 1 2007-1-29 32 1
6 1 2007-1-29 88 2根据A表的ID查询如下结果
ID NAME TYPE1_TODAY TYPE1_YESTERDAY TYPE2_TODAY TYPE2_YESERDAY TYPE1_SUM TYPE2_SUM
1 AA 33 65 23 34 130 145
解决方案 »
- 怎么把execl文件导入到oracle中
- Oracle建表
- RMB求解:如何用编程的方式实现事务处理?换句话说就是自己开发数据库事务处理
- windows停止oracle数据库
- 请问高手,一列数据中有一个时间记录,到这个时间就程行一个更新操作
- 过于rac数据库服务器修改密码
- 求一个sql语句(一条记录查出两条记录或一条记录的问题)
- 求教!在oracle中如何用变量传递表名实现删除表的操作??急急!!!!
- ORACLE 在运行中出现ORA-01000的错误提示。谁遇到过。
- 如何用程序实现将Excel中的数据导入Oracle9i中?
- 如以下数据列表??谢谢
- 在windows下连接unix oracle方法?
sum(case when (b.a_date = trunc(sysdate) and b.type = 1) then b.times else 0 end) as "TYPE1_TODAY",
sum(case when (b.a_date = trunc(sysdate)-1 and b.type = 1) then b.times else 0 end) as "TYPE1_YESTERDAY",
sum(case when (b.a_date = trunc(sysdate) and b.type = 2) then b.times else 0 end) as "TYPE2_TODAY",
sum(case when (b.a_date = trunc(sysdate)-1 and b.type = 2) then b.times else 0 end) as "TYPE2_YESERDAY",
sum(case when b.type = 1 then b.times else 0 end) as "TYPE1_SUM",
sum(case when b.type = 2 then b.times else 0 end) as "TYPE2_SUM",
from a,b
where a.id=b.a_id
group by a.id,a.name;