求最大值问题

[yangguangzhixing]

数据表department（系部）中数据如下
id · class person year
1 · A班 · 37 · 2008
2 · B班 · 35 · 2008
3 · A班 · 36 · 2009
4 · B班 · 37 · 2009
怎样检索出该系人数最多的那一年有多少人？
也就是检索出A班+B班最多一年有73人

[ACMAIN_CHM]

select MAX(k)
From (Select year,sum(person) as k from department group by year) t

[yangguangzhixing]

各位弟兄我用的是MySQL数据库，希望大家要针对MySQL数据库来写

[wwwwb]

select MAX(rs)
From (Select year,sum(person) as rs from department group by year) a

在MYSQL中可以运行

[gxg353]

 select year,sum(person) from department  group by year order by sum(person) desc  limit 1;

[langtaosha]

SELECT MAX(c) FROM (SELECT SUM(pcount) c FROM cls GROUP BY YEAR) temp;
或者
SELECT c FROM (SELECT SUM(pcount) c FROM cls GROUP BY YEAR) temp ORDER BY c DESC LIMIT 1;