我用ADOConnect+ADOQuery连接oracle数据库,连上之后在ADOQuery下写如下语句
select studentId,sum(studentMoney)
from Student
group by studentId
order by StudentId
结果打开数据集之后,系统老是提示ora-00979 not a group by expression
可是我在SQL*plus运行这句话完全正确
请问各位高手,错误出现在哪里?
select studentId,sum(studentMoney)
from Student
group by studentId
order by StudentId
结果打开数据集之后,系统老是提示ora-00979 not a group by expression
可是我在SQL*plus运行这句话完全正确
请问各位高手,错误出现在哪里?
from 消费表
group by 工号
order by 工号这样在oracle中没问题的
query1.Close;
query1.SQL.Clear;
query1.sql.add('select c1,sum(c5) from yb2 group by c1 order by c1);
query1.open;我的这个能在程序中执行