比较弱的问题,但很急!sos! a.c1是不是可以求和的数据类型?应该是select a.c2,sum(a.c1),b.c1 from a,b where a.c2=b.c1 group by a.c2 order by a.c2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum(a.c1),a.c2 from a,b where a.c2=b.c1 group by a.c2 order by a.c2;这样才行 select sum(a.c1),a.c1 from a,b where a.c1=a.c2 and a.c1=b.c1 group by a.c1 order by a.c1 或:select sum(a.c1),b.c3 from a,b where a.c1=a.c2 and a.c1=b.c1 group by a.c1 order by a.c1 select sum(a.c1),b.c1 from a,b where a.c2=b.c1 group by a.c2,b.c1 order by a.c2 试:select b.c1 t.sum from b,(select sum(a.c1) as sum,a.c2 as c2 from a group by a.c2) t where b.c1=t.c2 order by t.c2 Lastdrop(空杯) :select sum(a.c1),b.c1 from a,b where a.c2=b.c1 group by a.c2,b.c1 order by a.c2为正解,关键是group by子句。 Linux下C语言使用Oracle 有关csdn博客的问题 菜鸟问题,回滚 在先等求 数据库查询优化问题 再次提问:高级问题: 每天固定时间触发的触发器如何写 请大家指点(导出,同义词) oracle语法求助 一个老问题,但总是解决不了 数据导入问题 导库问题啊~ sqlloader能否只load一部分字段? 请问用VB编程访问ORACLE该怎么做?急!请帮忙!
select sum(a.c1),b.c1 from a,b where a.c2=b.c1 group by a.c2,b.c1 order by a.c2为正解,关键是group by子句。