不是group by的表达式
SNO SNAME SDEPT SCLASS SSEX SAGE
-------- -------- -------- -------- -------- --------
96001 马晓燕 cs 01 女 21
96002 黎明 cs 01 男 18
96003 刘东明 ma 01 男 18
96004 赵志勇 is 02 男 20
97001 马蓉 ma 02 女 19
97002 李成功 cs 01 男 20
97003 黎明 is 03 女 19
97004 李丽 cs 02 女 19
96005 司马志明 cs 02 男 18
select sage from student group by sno这句话怎么错的？
第1个回答 推荐于2016-09-09
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm),xn=MAX(XN) from bzrpcxt_cc group by bzrxm order by 1,2
或者：
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm),xn=MAX(XN) from bzrpcxt_cc group by bzrxm,XN order by 1,2
select c.id, c.name, count(s.id)
from classinfo as c left join student as s on s.claid = c.id
group by c.id, c.name
或者：
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm),xn=MAX(XN) from bzrpcxt_cc group by bzrxm,XN order by 1,2
select c.id, c.name, count(s.id)
from classinfo as c left join student as s on s.claid = c.id
group by c.id, c.name
第2个回答 2011-11-26
分组查询，你不对字段使用运算函数当然报错了!
select sage from student group by sno z
下面的就不会错。分组后对组求和!还可以求平均，求最值。
select sum(sage) from student group by sno z
我想你是想排序吧，那要用order by
select sage from student order by sno
select sage from student group by sno z
下面的就不会错。分组后对组求和!还可以求平均，求最值。
select sum(sage) from student group by sno z
我想你是想排序吧，那要用order by
select sage from student order by sno
第3个回答 2011-11-26
使用group by 子句，select 后面只能跟group by子句中的列或组函数本回答被提问者采纳
相似回答
大家正在搜
