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
- 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? On a relation named Loan of a bank:
- 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:
The following SQL query is executed:
SELECT L1.loannumber FROM Loan L1 WHERE L1.amount \(>\) (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branchname = 'SR Nagar');- An OTT company is maintaining a large disk-based relational database of different movies with the following schema :
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ?
View More Questions
Questions Asked in CUET exam
- Find the ratio of de-Broglie wavelengths of deuteron having energy E and \(\alpha\)-particle having energy 2E :
- CUET (UG) - 2026
- Dual nature of radiation and matter
- The de-Broglie wavelength associated with a ball of mass 150 g traveling at 30.0 m/s would be
- CUET (UG) - 2025
- de broglie hypothesis
- A clock shows the time as 3:15. What is the angle between the hour and minute hands?
- CUET (UG) - 2025
- Clock and Calendar
- If 36: 84 :: 42: X, then the value of X, is:
- CUET (UG) - 2025
- Ratio and Proportion
- The angles of elevation of the top of a tower from two points at a distance of 5 meters and 20 meters along the same straight line from the base of the tower, are complementary. Find the height of the tower.
- CUET (UG) - 2025
- Trigonometry
View More Questions