SQL Exercise: Employees retiring after 31-Dec-99 after 8 years

SQL employee Database: Exercise-30 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

30. From the following table, write a SQL query to identify those employees who retired after 31-Dec-99, completing eight years of service. Return employee name.

Sample table: employees

Pictorial Presentation:

SQL exercises on employee Database: List the employees who are retiring after 31-Dec-99 after completion of 8 years of service period

Sample Solution:

SELECT emp_name
FROM employees
WHERE hire_date + interval '96 months' > '1999-12-31';

Sample Output:

(3 rows)


The said query in SQL that selects the "emp_name" column from the "employees" table who were hired after December 31st, 1999.

The WHER clause filters the result set for the "hire_date" column plus 96 months (or 8 years) is greater than December 31st, 1999.

Practice Online

Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous SQL Exercise: Employees who earn more than 100 as daily salary.
Next SQL Exercise: List those employees whose salary is an odd value.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Follow us on Facebook and Twitter for latest update.