Sign in with Google
List Employees Hired After 2018
List Employees Hired After 2018
Query Explanation:
-
SELECT *
This selects all columns of data for each employee. -
FROM employees
This tells the database to look in the employees table. -
WHERE hire_date > '2018-12-31'
This filters the records to include only those where the hire_date is after December 31, 2018, i.e., hired in 2019 or later.
SQL Query:
SELECT *
FROM employees
WHERE hire_date > '2018-12-31';
Sample Output:
