mysql 聚合函数问题

[dlzp1991]

如表，查询各个职位工资最高的员工的信息
我用SELECT * FROM `emp` GROUP BY job HAVING sal = MAX(sal);
为什么只能查出两条记录

[RINK_1]

select * from emp A
where not exists (select 1 from emp where job=A.job and sal>A.sal)

[二月十六]

试试这样

SELECT  emp.*
FROM    emp
        JOIN ( SELECT   job ,
                        MAX(sal) AS sal
               FROM     emp
               GROUP BY job
             ) t ON emp.job = t.job
                    AND emp.sal = t.sal

[小野马1209]

改一改就可以

select job,max(sal) as maxsal from `emp` Group By job

[砸死牛顿的苹果]

这就是mysql 不强制规范 聚合查询的结果

[吉普赛的歌]

SELECT 
	`job`
	,MAX(`sal`) AS `max_sal` 
FROM `emp`
GROUP BY `job`

#3 说的对， 这个方面 MySQL 确实不如 SQL Server。 不过看楼主结贴率， ……