SQL查询分组的最大的三条数据

SELECT
 MAX( id ),
 company_id 
FROM
 xxdb.xxxx 
GROUP BY
 company_id;



SELECT d.name as dep,e.name as emp,e.salary  FROM employee e 
LEFT JOIN department d on e.departmentId = d.id 
where (
select count(DISTINCT e.salary) from employee e
 WHERE e.salary > e.salary and e.departmentId = e.departmentId
 )<3
ORDER BY e.departmentId,e.salary desc;


Select d.name as dep,e.name as emp,e.salary  From employee e 
Left join department d on e.departmentId = d.id 
where e.salary <= e.salary
group by e.id,e.departmentId,e.salary
HAVING count(e.id)<3
order by e.departmentId,e.salary desc;