w3resource

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 Expression: Calculate the total salaries payable to employees.

Relational Algebra Tree:

Relational Algebra Tree: Calculate the total salaries payable to employees.

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.