PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 1 : SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000 / SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000

Advertisement

Detailed Solution

सही उत्तर SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000 / SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000 है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Table Sales(Region, Amount) exists. Which query returns each region whose total sales exceed 10000? / तालिका Sales(Region, Amount) है। कौन-सी क्वेरी प्रत्येक क्षेत्र जिसका कुल विक्रय 10000 से अधिक है, लौटाएगी?

1.
SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000 / SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000
2.
SELECT Region, SUM(Amount) FROM Sales WHERE SUM(Amount) > 10000 GROUP BY Region / SELECT Region, SUM(Amount) FROM Sales WHERE SUM(Amount) > 10000 GROUP BY Region
3.
SELECT Region FROM Sales GROUP BY Region WHERE Amount > 10000 / SELECT Region FROM Sales GROUP BY Region WHERE Amount > 10000
4.
SELECT DISTINCT Region FROM Sales ORDER BY SUM(Amount) HAVING SUM(Amount) > 10000 / SELECT DISTINCT Region FROM Sales ORDER BY SUM(Amount) HAVING SUM(Amount) > 10000

Correct Answer: SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000 / SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 10000

Totals per region need GROUP BY with the threshold tested in HAVING; WHERE cannot filter on an aggregate, and DISTINCT with ORDER BY on an aggregate is syntactically invalid here. / प्रति क्षेत्र योग हेतु GROUP BY चाहिए और सीमा HAVING में जाँची जाती है; WHERE समुच्चय पर छनन नहीं कर सकता, और समुच्चय पर ORDER BY सहित DISTINCT यहाँ वाक्यविन्यासतः अमान्य है।

Downloaded from PrepSnap (prepsnap.in)