By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employees (
eid INT,
salary INT,
year YEAR
);
INSERT INTO employees VALUES
(1000, 10000, 2016),
(1000, 7500, 2015),
(1000, 6000, 2014),
(1001, 8000, 2016),
(1001, 7500, 2015),
(1002, 7500, 2016),
(1002, 7500, 2015),
(1002, 5000, 2014),
(1003, 6000, 2016),
(1003, 7000, 2015),
(1003, 5000, 2014);
SELECT
eid
FROM
(
SELECT
eid,
salary,
year,
salary - COALESCE(LEAD(salary) OVER(PARTITION BY eid ORDER BY year DESC), salary) AS diff
FROM
employees
) diff_salaries
GROUP BY
eid
HAVING
SUM(CASE WHEN diff>0 THEN 1 ELSE 0 END) >= 2
| eid |
|---|
| 1000 |