SQL Practice Question Tutorial

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:

❮ Previous Next ❯

Basic SQL (SELECT, WHERE, ORDER BY)