你需要分组 需要表关联条件SELECT " + " A.HAC_CD HAC_CD ," + " B.HAC_NM HAC_NM ," + " SUM(A.KINGAKU) AS KINGAKU_G ," + " A.KINGAKU KINGAKU " + " FROM TD_HACCHU A, TM_HACCHUSAKI B" + " where a.Ra = b.Rb " + " group by a.hac_cd "
目的就只是求和,但是这样写调试出来就是出错出错信息是这样的: single group のgroup function ありません 我这边用日文系统,痛苦ing!如果把SUM这句去掉select就对了,但是没有达到想要的目的. 另外,可不可以先select出KANGAKU这个字段,然后在select语句后将它求和呢? 具体写法是什么呢?
"SELECT " + " A.HAC_CD HAC_CD ," + " B.HAC_NM HAC_NM ," + " SUM(A.KINGAKU) AS KINGAKU_G ," + " A.KINGAKU KINGAKU " + " FROM TD_HACCHU A, TM_HACCHUSAKI B group by A.HAC_CD,B.HAC_NM,A.KINGAKU";
to beckhambobo(beckham):如果只用group by A.HAC_CD 有:错误信息是:java.sql.SQLException: ORA-00979: GROUP BYの式がありません。 改成你的这种,编译没有错误了,不过为什么group by 这三项呢?能帮我解释一下吗?thanks
-- -------------------------------------------------- ----------
1 求医问药 16
2 父母论坛 5
3 健康与性 3
4 美丽人生 2
5 性情中人 1
6 学术论坛 2
7 医疗改革 1
8 新药研究 1只能以分组形式查询显示!!
需要表关联条件SELECT " +
" A.HAC_CD HAC_CD ," +
" B.HAC_NM HAC_NM ," +
" SUM(A.KINGAKU) AS KINGAKU_G ," +
" A.KINGAKU KINGAKU " +
" FROM TD_HACCHU A, TM_HACCHUSAKI B" +
" where a.Ra = b.Rb " +
" group by a.hac_cd "
我这边用日文系统,痛苦ing!如果把SUM这句去掉select就对了,但是没有达到想要的目的.
另外,可不可以先select出KANGAKU这个字段,然后在select语句后将它求和呢? 具体写法是什么呢?
" A.HAC_CD HAC_CD ," +
" B.HAC_NM HAC_NM ," +
" SUM(A.KINGAKU) AS KINGAKU_G ," +
" A.KINGAKU KINGAKU " +
" FROM TD_HACCHU A, TM_HACCHUSAKI B group by A.HAC_CD,B.HAC_NM,A.KINGAKU";
改成你的这种,编译没有错误了,不过为什么group by 这三项呢?能帮我解释一下吗?thanks
A.HAC_CD,B.HAC_NM,A.KINGAKU
三个字段分组