Employers
Jobseekers
Recruiting Partners
Login
Join Hyring
Join Hyring
Lesson
Introduction
Syntax
Select
Select Distinct
Where
Order By
And, Or, Not
Insert Into
Null Values
Update
Delete
Select Top
Aggregate Functions
MIN and MAX
COUNT
SUM
AVG
Like
Wildcards
In
Between
Aliases
Joins
Inner Join
Left Join
Right Join
Full Join
Self Join
Union
Group By
Having
Case
Comments
Operators
Create DB
Drop DB
Create Table
Drop Table
Alter Table
Constraints
Not Null
Unique
Primary Key
Foreign Key
Check
Default
Indexes
Auto Increment
Dates
Views
Injection
Back to lesson
SQL Aggregate Functions
Total number of employees
How many distinct departments
Number of employees per department
Run
Language:
SQL
Change Theme
Change orientation
SELECT COUNT(*) AS total_employees FROM Employees;
SELECT COUNT(*) AS total_employees FROM Employees;
Output
Click Run to execute this code.