Question:
If column "Payment" contains the data set \{10000, 15000, 25000, 10000, 15000\}, what will be the output after the execution of the given query?
\[
\text{SELECT SUM(DISTINCT PAYMENT) FROM EMPLOYEE;}
\]
If column "Payment" contains the data set \{10000, 15000, 25000, 10000, 15000\}, what will be the output after the execution of the given query?
\[
\text{SELECT SUM(DISTINCT PAYMENT) FROM EMPLOYEE;}
\]
Show Hint
The "DISTINCT" keyword in SQL ensures that only unique values are considered in aggregate functions like SUM.
Updated On: Apr 24, 2025
- 75000
- 25000
- 10000
- 50000
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The query uses the "DISTINCT" keyword, which means it will sum the unique values from the "Payment" column. The unique payments are: 10000, 15000, and 25000. Therefore, the sum is:
\[
10000 + 15000 + 25000 = 50000
\]
Thus, the output will be 50000.
Was this answer helpful?
0
0
Top Questions on SQL
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
On a relation named Loan of a bank:
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?
View More Questions
Questions Asked in CUET exam
- The components of computerized accounting system refer to:
- CUET (UG) - 2024
- Using a Computerized Accounting System
- S and T are partners in a firm sharing profits in the ratio of 3:2. They admit U as a new partner. S surrenders \(\frac{1}{4}\) of his share and T surrenders 1/3 of his share in favour of U. Sacrificing ratio of S and T will be:
Choose the correct answer from the options given below:- CUET (UG) - 2024
- Profit sharing ratio
- Calculate goodwill on the basis of two years’ purchase of average profit of the last four years. Profit/Loss of the last four years is given below:
• 2020: 1,00,000
• 2021: 1,50,000
• 2022: 2,20,000
• 2023: (70,000)
Additional information: Closing Stock of the year 2022 was overvalued by 20,000.- CUET (UG) - 2024
- Profit and Loss Account
- A die is rolled thrice. What is the probability of getting a number greater than $4$ in the first and second throws and a number less than $4$ in the third throw?
- CUET (UG) - 2024
- Probability
- Six people E, H, K, M, S, and U are seated in a circle facing the center. U and H are immediate neighbors of M. E is the only person sitting between K and S. H is to the immediate right of S. Who is to the immediate right of U?
- CUET (UG) - 2024
- Statements and Inferences
View More Questions