EN
MS SQL Server - AVG() function example
0 points
In this article, we would like to show you how to use AVG() function in MS SQL Server.
Quick solution:
xxxxxxxxxx1
SELECT AVG([column_name]) FROM [table_name];To show how the AVG() function works, we will use the following table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will display the average salary.
Query:
xxxxxxxxxx1
SELECT AVG([salary]) FROM [users];Output:
In this example, we will display every user whose salary is less than average. This shows that we are able to use AVG() function in different places in query (e.g. as subselect or having).
Query:
xxxxxxxxxx1
SELECT * FROM [users] 2
WHERE [salary] < (SELECT AVG([salary]) 3
FROM [users]);Output:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE [users] (2
[id] INT IDENTITY(1,1),3
[name] VARCHAR(50) NOT NULL,4
[surname] VARCHAR(50) NOT NULL,5
[department_id] INT,6
[salary] DECIMAL(15,2) NOT NULL,7
PRIMARY KEY ([id])8
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO [users]2
([name], [surname], [department_id], [salary])3
VALUES4
('John', 'Stewart', 1, '3512.00'),5
('Chris', 'Brown', 2, '1344.00'),6
('Kate', 'Lewis', 3, '6574.00'),7
('Ailisa', 'Gomez', NULL, '6500.00'),8
('Gwendolyn', 'James', 2, '4200.00'),9
('Simon', 'Collins', 4, '3320.00'),10
('Taylor', 'Martin', 2, '1500.00'),11
('Andrew', 'Thompson', NULL, '2100.00');