select a.cons_id,sum(a.plate_cap) plate_cap,a.actual_start_Date,a.actual_stop_use_date,
b.zhh,b.hm,d.amt_ym, (d.t_factor*d.this_read) as xl
from g_tran a ,e_calc_inv b ,c_cons c,arc_r_data d
where a.run_status_code='01'
and a.cons_id<>0 and b.jbdj<>38
and a.cons_id=c.cons_id and b.zhh=c.cons_no
and d.cons_no=c.cons_no and d.read_type_code='111'and plate_cap>=315
and rownum<=10
group by a.cons_id,a.actual_start_Date,
a.actual_stop_use_date,b.zhh,b.hm,d.amt_ym,
d.t_factor,d.this_read 上面的sql语句中,有sum求和,还有2个字段的乘积:(d.t_factor*d.this_read) as xl,其中在group by 字句中也对d.t_factor,d.this_read 进行了分组,不知道这样是不是正确,请高手指教,在线等!!!
b.zhh,b.hm,d.amt_ym, (d.t_factor*d.this_read) as xl
from g_tran a ,e_calc_inv b ,c_cons c,arc_r_data d
where a.run_status_code='01'
and a.cons_id<>0 and b.jbdj<>38
and a.cons_id=c.cons_id and b.zhh=c.cons_no
and d.cons_no=c.cons_no and d.read_type_code='111'and plate_cap>=315
and rownum<=10
group by a.cons_id,a.actual_start_Date,
a.actual_stop_use_date,b.zhh,b.hm,d.amt_ym,
d.t_factor,d.this_read 上面的sql语句中,有sum求和,还有2个字段的乘积:(d.t_factor*d.this_read) as xl,其中在group by 字句中也对d.t_factor,d.this_read 进行了分组,不知道这样是不是正确,请高手指教,在线等!!!
解决方案 »
- 有木监控程序执行oracle语句的工具
- 请教一个大数据量运算的问题
- 怎么实现通过外网于远程oracle数据库的对接??
- 怎么把这五条SQL语句合并成一条SQL语句?
- procedure必须声明组件
- 关于oracle,请各位大哥帮忙!
- 求Oracle 增加字段语句
- 生啦!生啦~~~~快叫喜婆~~~~呵呵~~~~~~~~~~~~~~散分!!!
- 在oracle中怎样实现sqlserver中的 isnull(tab.field,"aa") 请大家指教!!!!!!
- 新年好,祝大家新的一年中大事有成。我现在在PL/SQL中怎样建表,又怎样使用程序与它连接起来
- 两个表a和b, a.c1和b.c1是关联的,想建一个a和b当作同一个表的唯一索引或主键的
- Oracle函数的一个问题,求解决
SELECT a.cons_id,
SUM (a.plate_cap) plate_cap,
a.actual_start_Date,
a.actual_stop_use_date,
b.zhh,
b.hm,
d.amt_ym,
(d.t_factor * d.this_read) AS xl
FROM g_tran a,
e_calc_inv b,
c_cons c,
arc_r_data d
WHERE a.run_status_code = '01'
AND a.cons_id <> 0
AND b.jbdj <> 38
AND a.cons_id = c.cons_id
AND b.zhh = c.cons_no
AND d.cons_no = c.cons_no
AND d.read_type_code = '111'
AND plate_cap >= 315
AND ROWNUM <= 10
GROUP BY a.cons_id,
a.actual_start_Date,
a.actual_stop_use_date,
b.zhh,
b.hm,
d.amt_ym,
(d.t_factor * d.this_read)换这样