| CARVIEW |
Select Language
HTTP/2 200
content-type: text/html; charset=utf-8
date: Sat, 09 Aug 2025 09:27:11 GMT
permissions-policy: interest-cohort=()
strict-transport-security: max-age=31536000; includeSubDomains
server: nginx
cache-control: s-maxage=60283, max-age=0
x-powered-by: Next.js
etag: "59hwcg1vc88dle"
content-encoding: gzip
x-xss-protection: 1; mode=block
x-content-type-options: nosniff
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'self' http: https: ws: wss: data: blob: 'unsafe-eval' 'unsafe-inline'; frame-ancestors 'self';
vary: Accept-Encoding
x-cache: Miss from cloudfront
via: 1.1 8245690a788e53c4f00d1ddf4345d9ec.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM78-P9
x-amz-cf-id: Oa0sCM97qi3S9PJLZ7nJylgEHQOuTeDQlqaBwDXFKcHoZuGk1kpc8w==
Write an SQL query to retrieve the names of employees who joined in the year 2021. 
- Courses
- Tutorials
- Practice
- Jobs
Data Structure
Java
Python
HTML
Interview Preparation
Interview Preparation
- Interview Preparation For Software Developers
- Must Coding Questions - Company-wise
- Must Do Coding Questions - Topic-wise
- Company-wise Practice Problems
- Company Preparation
- Competitive Programming
- Software Design-Patterns
- Company-wise Interview Experience
- Experienced - Interview Experiences
- Internship - Interview Experiences
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 QuizShare your thoughts in the comments
GeeksforGeeks
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