Write an SQL query to retrieve the names of employees who joined in the year 2021.

Last Updated :
Discuss
Comments

Write an SQL query to retrieve the names of employees who joined in the year 2021.

SELECT name FROM employees WHERE JOIN_YEAR = 2021;

SELECT name FROM employees WHERE JOIN_DATE LIKE '2021%';

SELECT name FROM employees WHERE YEAR(JOIN_DATE) = 2021;

SELECT name FROM employees WHERE JOIN_DATE BETWEEN '2021-01-01' AND '2021-12-31';

This question is part of this quiz :

SQL Query-Based Questions Quiz
Tags:
SQL
SQL Quiz
Databases
Share your thoughts in the comments
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy