oracle 中一个关于 SQL 语句的问题(50分)

P

peterluolaw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #1

请问各位,下面的这段 SQL 代码到底有什么问题? 为什么 ORACLE 8I 老是
提示:"Oracle]ORA-00979: 不是 GROUP BY 表达式"!!??
select ser_num, chi_brf, send_per from qianzgl where ser_num like '182002%' group by send_per

 

春

春意

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #2

你分组查询干什么？
是对字段求和，还是求个数，还是什么？
如果改成这样，包你不错！！
select count(ser_num), send_per from qianzgl where ser_num like '182002%' group by send_per

 

F

fxjpost

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #3

這代碼本身就有問題吧，你要全部group by 進來才行呀

 

F

foodbird

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #4

这是SQL 2000中的代码和错误，问题的原因是一样的
select bookid from inf_book group by booktype
列 'inf_book.BOOKID' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。

 

人

人在昆明

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #5

select ser_num, chi_brf, send_per
from qianzgl
where ser_num like '182002%'
group by ser_num, chi_brf, send_per
是不是应该
select sum(ser_num) ser_num, chi_brf, send_per
from qianzgl
where ser_num like '182002%'
group by chi_brf, send_per
呵呵！

 

P

peterluolaw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-01

• #6

多人接受答案了。