w3resource
SQL exercises

SQL exercises on employee Database: List the employees in ascending order of seniority who joined on 1-MAY-91,or 3-DEC-91, or 19-JAN-90

SQL employee Database: Exercise-72 with Solution

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

72. Write a query in SQL to list the employees in ascending order of seniority who joined on 1-MAY-91,or 3-DEC-91, or 19-JAN-90.

Sample table: employees


Sample Solution:

SELECT *
FROM employees
WHERE hire_date IN ('1991-5-01',
                    '1991-12-03',
                    '1990-01-19')
ORDER BY hire_date ASC;

Sample Output:

 emp_id | emp_name | job_name | manager_id | hire_date  | salary  | commission | dep_id
--------+----------+----------+------------+------------+---------+------------+--------
  66928 | BLAZE    | MANAGER  |      68319 | 1991-05-01 | 2750.00 |            |   3001
  69062 | FRANK    | ANALYST  |      65646 | 1991-12-03 | 3100.00 |            |   2001
  69000 | JULIUS   | CLERK    |      66928 | 1991-12-03 | 1050.00 |            |   3001
(3 rows)

Practice Online


Sample Database: employee

employee database structure

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

Previous: Write a query in SQL to display the location of CLARE.
Next: Write a query in SQL to list the employees who are drawing the salary less than 1000 and sort the output in ascending order on salary.

What is the difficulty level of this exercise?