Question

Answer (Detailed Solution Below)

Option 4 : SELECT Dept FROM Emp GROUP BY Dept HAVING COUNT(*) > 5; / SELECT Dept FROM Emp GROUP BY Dept HAVING COUNT(*) > 5;

Detailed Solution

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

Key Points

Helpful?

prepsnap.in • Part -A

Question:

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

SELECT Dept FROM Emp WHERE COUNT(*) > 5 GROUP BY Dept; / SELECT Dept FROM Emp WHERE COUNT(*) > 5 GROUP BY Dept;

SELECT Dept FROM Emp GROUP BY Dept WHERE COUNT(*) > 5; / SELECT Dept FROM Emp GROUP BY Dept WHERE COUNT(*) > 5;

SELECT Dept, COUNT(*) FROM Emp HAVING COUNT(*) > 5; / SELECT Dept, COUNT(*) FROM Emp HAVING COUNT(*) > 5;

SELECT Dept FROM Emp GROUP BY Dept HAVING COUNT(*) > 5; / SELECT Dept FROM Emp GROUP BY Dept HAVING COUNT(*) > 5;

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

Aggregates cannot appear in WHERE (it runs before grouping), and HAVING without GROUP BY treats the whole table as one group; only (d) groups first and then filters the groups. / समुच्चय फंक्शन WHERE में नहीं आ सकते (वह समूहीकरण से पहले चलता है), और GROUP BY के बिना HAVING पूरी तालिका को एक समूह मानता है; केवल (d) पहले समूह बनाकर फिर समूहों को छाँटता है।

Downloaded from PrepSnap (prepsnap.in)