SQL方面的问题~

[moonshowder]

关于SQL方面的一个问题~
一个表，其中有dept和age 2个列。怎么取得平均年龄最大的部门？？
select dept,avg(age) from table group by dept having max(avg(age));为什么不对？？？

[dawugui]

select top 1 * from
(select dept,avg_age avg(age) from table group by dept) t order by avg_age desc

[-狙击手-]

select   top 1 dept,avg(age) as avg_age
from   table   
group   by   dept
order by avg_age desc

[moonshowder]

我想使用函数MAX~为什么那样不行？

[dawugui]

--可直接:
select top 1 dept,avg_age = avg(age) from table group by dept order by avg_age desc

[-狙击手-]

having max() > 100

这样才行

[moonshowder]

select top 1 dept,avg(age) from test group by dept order by avg(age) desc;
top 1无法在MYSQL里运行。。。。。。

[-狙击手-]

mysql

select dept,avg(age) from test group by dept order by avg(age) desc limit 1