| CARVIEW |
Select Language
HTTP/2 200
content-type: text/html; charset=utf-8
date: Sat, 09 Aug 2025 08:52:19 GMT
permissions-policy: interest-cohort=()
strict-transport-security: max-age=31536000; includeSubDomains
server: nginx
cache-control: s-maxage=54032, max-age=0
x-powered-by: Next.js
etag: "2jyyy23tmw7o31"
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 1c74c3116d2446586ce4ea1279581ace.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM78-P9
x-amz-cf-id: UuWOU_mdh-fGWnkXvRgcU_-6GWJntiW_3ebQelaMWKAvHceXmD1D5Q==
Write an SQL query to retrieve the number of employees in each department. 
- 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 number of employees in each department.
Last Updated :
Discuss
Comments
Write an SQL query to retrieve the number of employees in each department.
SELECT COUNT() FROM employees ORDER BY department;
SELECT COUNT(department) FROM employees GROUP BY department;
SELECT COUNT(*) FROM employees GROUP BY department;
SELECT COUNT(*) AS employees_count, department FROM employees;
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