PrepSnap logoPrepSnap
Pass

Question

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

Option 2 : SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5 / SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5

Advertisement

Detailed Solution

सही उत्तर SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5 / SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5 है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Which query correctly lists departments having more than 5 employees? / कौन-सी क्वेरी 5 से अधिक कर्मचारियों वाले विभागों को सही सूचीबद्ध करती है?

1.
SELECT DeptId, COUNT(*) FROM Emp WHERE COUNT(*) > 5 GROUP BY DeptId / SELECT DeptId, COUNT(*) FROM Emp WHERE COUNT(*) > 5 GROUP BY DeptId
2.
SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5 / SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5
3.
SELECT DeptId FROM Emp GROUP BY DeptId WHERE COUNT(*) > 5 / SELECT DeptId FROM Emp GROUP BY DeptId WHERE COUNT(*) > 5
4.
SELECT DeptId, COUNT(*) FROM Emp HAVING COUNT(*) > 5 / SELECT DeptId, COUNT(*) FROM Emp HAVING COUNT(*) > 5

Correct Answer: SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5 / SELECT DeptId, COUNT(*) FROM Emp GROUP BY DeptId HAVING COUNT(*) > 5

Aggregate conditions must be tested in HAVING after GROUP BY forms the groups; WHERE cannot contain aggregates and HAVING without GROUP BY collapses to one group. / समुच्चय शर्तें GROUP BY से समूह बनने के बाद HAVING में जाँची जाती हैं; WHERE में समुच्चय नहीं आ सकता और GROUP BY बिना HAVING एक समूह में सिमटता है।

Downloaded from PrepSnap (prepsnap.in)