w3resource

MySQL Exercise: Display the name and hire date for all employees who were hired in 1987

MySQL Restricting and Sorting Data: Exercise-4 with Solution

Write a query to display the name (first_name, last_name) and hire date for all employees who were hired in 1987.

Sample table: employees


Code:

-- Selecting the first_name, last_name, and hire_date columns
SELECT first_name, last_name, hire_date
-- Selecting data from the employees table
FROM employees 
-- Filtering the result set to include only rows where the year part of the hire_date is like '1987%'
WHERE YEAR(hire_date) LIKE '1987%';

Explanation:

  • This SQL query selects the first_name, last_name, and hire_date columns from the employees table.
  • The WHERE clause filters the result set to include only those rows where the year part of the hire_date column starts with '1987'.
  • The YEAR() function is used to extract the year from the hire_date column, and the LIKE operator is used to match years that start with '1987'.
  • This query is useful when you want to retrieve employees who were hired in a specific year, in this case, employees hired in the year 1987.

Pictorial Presentation of the above query

Pictorial: Query to display the names and hire date for all employees who were hired in 1987

 

MySQL Code Editor:

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

Previous:Write a query to display the name (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000 and are in department 30 or 100.
Next:Write a query to display the first_name of all employees who have both "b" and "c" in their first name.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.