Employees Same Salary

The Problem

The Query

SELECT salary, COUNT(*) AS num_employees
FROM employees
GROUP BY salary
HAVING COUNT(*) > 1;

How it Works

Summary

• GROUP BY the salary, then HAVING COUNT(*) > 1 finds shared values.
• HAVING filters groups (WHERE filters rows).

समस्या

Query

SELECT salary, COUNT(*) AS num_employees
FROM employees
GROUP BY salary
HAVING COUNT(*) > 1;

कैसे काम करता है

सारांश

• Salary पर GROUP BY करें, फिर HAVING COUNT(*) > 1 shared values ढूंढता है।
• HAVING groups filter करता है (WHERE rows filter करता है)।