Question

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)​

Answer 1

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

Answer 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