Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 40 of 79

Database Query using SQL — Question 11

Back to all questions
11
Question

Question 11

Consider a table named Employees with columns — EName, Age, Salary and Designation. Which SQL statement do we use to find out the total salary given to employees?

  1. Select SUM(Salary) From Employees;
  2. Select COUNT (*) From Employees;
  3. Select FIND (*) From Employees;
  4. Select SUM () From Employees;
Answer

Select SUM(Salary) From Employees;

Reason — The SQL statement used to find out the total salary given to employees is SELECT SUM(Salary) FROM Employees;. This statement utilizes the SUM() function to calculate the total value of the 'Salary' column from the 'Employees' table.