w3resource

SQL exercises on employee Database: List all the employees joined on 1st may 91

SQL employee Database: Exercise-27 with Solution

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

27. Write a query in SQL to list all the employees joined on 1st may 91.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List all the employees joined on 1st may 91

Sample Solution:

SELECT *
FROM employees
WHERE hire_date = '1991-05-01';

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
(1 row)

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 list the employee name, and job_name who are not working under a manager.
Next: Write a query in SQL to list the id, name, salary, and experiences of all the employees working for the manger 68319.

What is the difficulty level of this exercise?



Inviting useful, relevant, well-written and unique guest posts