我自己整出个这查询,能弄出结果,不过很笨拙: SELECT v.emp_id,v.city,v.salary FROM v JOIN (SELECT city,MAX(salary)as salary FROM v GROUP BY city) s WHERE v.city=s.city AND v.salary=s.salary; 各位支招啊!
SELECT v.emp_id,v.city,v.salary FROM v JOIN (SELECT city,MAX(salary)as salary FROM v GROUP BY city) s ON v.city=s.city AND v.salary=s.salary;
SELECT v.emp_id,v.city,v.salary
FROM
v
JOIN
(SELECT city,MAX(salary)as salary FROM v GROUP BY city) s
WHERE v.city=s.city AND v.salary=s.salary;
各位支招啊!
FROM
v
JOIN
(SELECT city,MAX(salary)as salary FROM v GROUP BY city) s
ON v.city=s.city AND v.salary=s.salary;
[征集]分组取最大N条记录方法征集,及散分....
where not exists (select 1 from v where city=a.city and salary>a.salary)