CBSE BOARD XII, asked by pritisah59, 7 months ago

If Column “Salary” contains the data set {10000, 15000, 25000, 10000, 15000} what will be the output after the execution of the given query?
Select Sum(distinct SALARY) from EMPLOYEE
(1 Point)​

Answers

Answered by yyhanandmisra
2

Answer:

50000

Explanation:

Here, we have to check for distinct entries, which are:

10000

15000

25000

Adding all these values will give us 50000, which would be our answer

I hope that it helps you !!

Give an Upvote if it does

Answered by pruthaasl
2

Answer:

The output of the given query will be 50000.

Explanation:

  • We are given a data set containing 5 data elements 10000, 15000, 25000, 10000, and 15000.
  • The query to be executed on this data set is Select Sum(distinct SALARY) from EMPLOYEE.
  • It means that a table named EMPLOYEE has different sets of data.
  • In this table, a column named SALARY keeps a record of the employee salary.
  • The SALARY column has some amount of salaries repeated. For example, 10000 and 15000.
  • The command distinct SALARY implies that the repeated salaries are to be considered only once.
  • These distinct salaries are then added and their sum is displayed.

Therefore, the execution of the given query gives the output as 50000.

#SPJ2

Similar questions