Question
Given the following SQL query: SELECT department
_ id, COUNT(*) AS employee _ count FROM employees GROUP BY department_id HAVING COUNT(*) > 5; What is the purpose of the HAVING clause in this query?Solution
The HAVING clause is used in SQL to filter groups created by the GROUP BY clause based on an aggregate function. 1. Aggregate Filtering: Unlike the WHERE clause, which filters rows before grouping, HAVING applies conditions on grouped data. 2. Purpose in Query: In this query, the HAVING clause ensures that only those departments with more than 5 employees (as determined by COUNT(*)) are included in the result set. 3. Execution Process: o The GROUP BY groups the data by department_id. o The COUNT(*) calculates the number of employees in each department. o The HAVING clause filters out groups where COUNT(*) is less than or equal to 5. This differentiation between WHERE and HAVING is crucial for effective data querying. Why Other Options Are Incorrect: • A) To filter rows before grouping them: The WHERE clause performs pre-grouping filtering, not HAVING. • C) To apply a condition to the entire table: HAVING only applies conditions to grouped results. • D) To apply conditions only to the COUNT(*) function: While COUNT(*) is used, the HAVING clause applies to groups as a whole. • E) To sort the rows by department_id: Sorting is achieved using the ORDER BY clause, not HAVING.
Which city is home to Astr Defence, the company that launched India’s first Red Dot Sight Pistol, named Phantom?
Which two entities signed an MoU to facilitate capital market access for MSMEs in the defence sector?
Fill in the blank above in passeage : The Global Collaborative Co - Financing Platform launched by MDBs aims to ______ .
The main objective of the 8th Future Investment Initiative (FII) in Riyadh, where Union Minister Piyush Goyal will participate, is to:
Who is roped as the brand ambassador of PharmEasy?
Which of the statements given above is/are Incorrect about SCO?
1. The Samarkand declaration was adopted by the council of heads of government of...
How many new SIDBI branches were inaugurated in Karnataka by the Finance Minister?
According to the Economic Survey 2024-25, which two emerging sectors in India are providing enhanced opportunities for job creation, in alignment with t...
Which gas is produced in the Haber Process?
The Ahmedabad Police Command and Control Centre uses which technology for enhanced surveillance?