Question
1.
2.
3.
4.
Answer (Detailed Solution Below)
Option 1 : SELECT dept, COUNT(*) FROM Emp GROUP BY dept HAVING COUNT(*) > 5
Advertisement
Detailed Solution
सही उत्तर SELECT dept, COUNT(*) FROM Emp GROUP BY dept HAVING COUNT(*) > 5 है।
Key Points
Helpful?
prepsnap.in • Part -AQuestion:
Which query correctly lists each department having more than 5 employees, along with its headcount? / कौन-सी क्वेरी 5 से अधिक कर्मचारियों वाले प्रत्येक विभाग को उसकी संख्या सहित सही ढंग से सूचीबद्ध करती है?
1.
SELECT dept, COUNT(*) FROM Emp GROUP BY dept HAVING COUNT(*) > 5
2.
SELECT dept, COUNT(*) FROM Emp WHERE COUNT(*) > 5 GROUP BY dept
3.
SELECT dept, COUNT(*) FROM Emp HAVING COUNT(*) > 5
4.
SELECT dept, COUNT(*) FROM Emp GROUP BY dept WHERE COUNT(*) > 5
Correct Answer: SELECT dept, COUNT(*) FROM Emp GROUP BY dept HAVING COUNT(*) > 5
Aggregates can only be filtered with HAVING after grouping; WHERE cannot use COUNT(*), and HAVING requires GROUP BY. / समुच्चयों को समूहीकरण के बाद HAVING से छाँटा जाता है; WHERE में COUNT(*) नहीं चलता और HAVING को GROUP BY चाहिए।
Downloaded from PrepSnap (prepsnap.in)