假设您有一个名为"员工"的表,列"员工_id", "名字", "开始_日期", "工资"和"管理者_id". 写一个SQL查询,找到每个管理者的前3名最高薪酬的员工.
Here is a SQL query that will return the top 3 highest paid employees for each manager: 

```
SELECT m.name AS manager_name, e.name AS employee_name, e.salary 
FROM employees e 
JOIN employees m ON e.manager_id = m.employee_id 
WHERE (SELECT COUNT(*) FROM employees WHERE manager_id = m.employee_id AND salary >= e.salary) <= 2 
ORDER BY manager_name, salary DESC;
```

This query will join the table "employees" to itself on the manager_id, and then rank employees within their manager group according to their salary, choosing only the top 3 by using a subquery with a count. It will return the manager name, employee name, and salary for each of the top 3 highest paid employees, sorted by manager name and salary in descending order.