SELECT MIN(RID) AS RID, name, Description,phone, MIN(START_TIME) AS START_TIME, MIN(end_TIME)
AS end_TIME, MIN(week) AS week,status,type,send_type
FROM SMSALARMNOTICE GROUP BY name,phone,status,send_type,Description
这条sql语句那里有错误,toal报出 ORA-00979: not a GROUP BY expression这个错误,应该怎么解决,在线等
AS end_TIME, MIN(week) AS week,status,type,send_type
FROM SMSALARMNOTICE GROUP BY name,phone,status,send_type,Description
这条sql语句那里有错误,toal报出 ORA-00979: not a GROUP BY expression这个错误,应该怎么解决,在线等
解决方案 »
- 按出生日期和性别统计年龄段的人数
- 如何UPDATE 多条满足条件的纪录(急!)
- 我想把SqA返回給某個變量,要怎么實現啊
- 数据转入oracle的问题
- 要象sql-server一样如何操作select top 1 * from table
- 如何优化Oracle表.
- 大家多照顾,初学,来看看这个问题,谢谢
- 关于大数据量的查询问题,我用了两个WHILE,但发觉速度为什么这么慢,请有经验的人来评评(在线等待)
- 十万火急求助:red hat linux 8.0 下如何安装oracle9.0或者8.0
- oracle统计查询怎么写?
- 不同帐号连接oracle的速度差别很大是为什么?
- 如何在一个表中查找姓名重复的记录
SELECT MIN(RID) AS RID, name, Description,phone, MIN(START_TIME) AS START_TIME, MIN(end_TIME)
AS end_TIME, MIN(week) AS week,status,type,send_type
FROM SMSALARMNOTICE
GROUP BY name,phone,status,send_type,Description,type----group by 少写了type字段