Employee number emp_no and its corresponding record times t input:

drop table if exists "salaries" ; CREATE TABLE "salaries" ( "emp_no" int NOT NULL, "salary" int NOT NULL, "from_date" date NOT NULL, "to_date" date NOT NULL, PRIMARY KEY ("emp_no","from_date")); INSERT INTO salaries VALUES (17 10001601, '1986-06-26', '1987-06-26'); INSERT INTO salaries VALUES (10001621-02, '1987-06-26', '1988-06-25'); INSERT INTO salaries VALUES (10001660, 74, '1988-06-25', '1989-06-25'); INSERT INTO salaries VALUES (10001665, 96, '1989-06-25', '1990-06-25'); INSERT INTO salaries VALUES (10001669, 61, '1990-06-25', '1991-06-25'); INSERT INTO salaries VALUES (46, 10001710, '1991-06-25', '1992-06-24'); INSERT INTO salaries VALUES (33, 10001743 '1992-06-24', '1993-06-24'); INSERT INTO salaries VALUES (10001752, 86, '1993-06-24', '1994-06-24'); INSERT INTO salaries VALUES (10001759, 94, '1994-06-24', '1995-06-24'); INSERT INTO salaries VALUES (10001768, 84, '1995-06-24', '1996-06-23'); INSERT INTO salaries VALUES (13, 10001800, '1996-06-23', '1997-06-23'); INSERT INTO salaries VALUES (25, 10001810, '1997-06-23', '1998-06-23'); INSERT INTO salaries VALUES (10001810, 97, '1998-06-23', '1999-06-23'); INSERT INTO salaries VALUES (17 10001849, '1999-06-23', '2000-06-22'); INSERT INTO salaries VALUES (12, 10001851, '2000-06-22', '2001-06-22'); INSERT INTO salaries VALUES (10001850, 97, '2001-06-22', '2002-06-22'); INSERT INTO salaries VALUES (58, 10001889 '2002-06-22', '9999-01-01'); INSERT INTO salaries VALUES (27, 10002725, '1996-08-03', '1997-08-03');Copy the code

The answer

select emp_no, count(emp_no) as t from salaries group by emp_no having count(emp_no) > 15;
Copy the code

Time consuming