Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- `department_id`,
- (SELECT DISTINCT
- `e2`.`salary`
- FROM
- `employees` AS `e2`
- WHERE
- `e2`.`department_id` = `e1`.`department_id`
- ORDER BY `e2`.`salary` DESC
- LIMIT 2 , 1) AS `third_highest_salary`
- FROM
- `employees` AS `e1`
- GROUP BY `department_id`
- HAVING `third_highest_salary` IS NOT NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement