SQL语句问题

[wzllin]

select name1,country,age from person order by a compute sum(age),max(age),min(age) by country

[wzllin]

井低之蛙；

[柯本]

这是最基本的错误,SQL的聚合函数,前面的字段必须放入group by 中,且聚合函数必须在from的前面,如:
select country , sum(age),max(age),min(age) from person group by country

[wxch]

一楼说的正确。

[ShyHat]

SQL中一旦用了聚合函数,除 order by的字段外,其他字段都必须用聚合函数来写

[xiaosl0817]

我汗。。LZ的语法错的好厉害，1楼说的对，
而且，头次看见这样写的
select name1,country,age from person order by a compute sum(age),max(age),min(age) by country
要写也是
select name1,country,age,sum(age) a,max(age) b,min(age) c from person
然后再加上group by name1,country,age
最后才是order by

[chen7872]

不明白,你能不能说明你要实现的结果

[kangji]

select name1,country,age, sum(age), max(age), min(age)
from person
group by age
order by contry

[wzllin]

请大家注意“compute ”词