w3resource

SQL exercises on employee Database: List the employees those who joined in company before 19th of the month

SQL employee Database: Exercise-34 with Solution

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

34. Write a query in SQL to list the employees those who joined in company before 19th of the month.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List the employees those who joined in company before 19th of the month

Sample Solution:

SELECT *
FROM employees
WHERE to_char(hire_date,'DD') < '19';

Sample Output:

 emp_id | emp_name | job_name  | manager_id | hire_date  | salary  | commission | dep_id
--------+----------+-----------+------------+------------+---------+------------+--------
  68319 | KAYLING  | PRESIDENT |            | 1991-11-18 | 6000.00 |            |   1001
  66928 | BLAZE    | MANAGER   |      68319 | 1991-05-01 | 2750.00 |            |   3001
  67832 | CLARE    | MANAGER   |      68319 | 1991-06-09 | 2550.00 |            |   1001
  65646 | JONAS    | MANAGER   |      68319 | 1991-04-02 | 2957.00 |            |   2001
  69062 | FRANK    | ANALYST   |      65646 | 1991-12-03 | 3100.00 |            |   2001
  63679 | SANDRINE | CLERK     |      69062 | 1990-12-18 |  900.00 |            |   2001
  68454 | TUCKER   | SALESMAN  |      66928 | 1991-09-08 | 1600.00 |       0.00 |   3001
  69000 | JULIUS   | CLERK     |      66928 | 1991-12-03 | 1050.00 |            |   3001
(8 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 list the employees who joined in the month of APRIL.
Next: Write a query in SQL to list the employees who are SALESMAN and gathered an experience which month portion is more than 10.

What is the difficulty level of this exercise?



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