PostgreSQL Basic SELECT Statement: Calculate the total salaries payable to employees

6. Write a query to get the total salaries payable to employees.

Sample Solution:

Code:

-- Calculating the total sum of salaries for all employees
SELECT SUM(salary) 
-- From the employees table
FROM employees;

Explanation:

This PostgreSQL code calculates the total sum of salaries for all employees in the database. The SUM() function is used to add up all the salary values from the salary column of the employees table.

Sample table: employees

Output:

pg_exercises=# SELECT SUM(salary)
pg_exercises-# FROM employees;
    sum
-----------
 691400.00
(1 row)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to get the employee ID, name (first_name, last_name) and salary in ascending order according to their salary.
Next: Write a query to get the maximum and minimum salary paid to the employees.