Free tutorials in Hindi & English Clean code examples with output Mobile friendly learning

MySQL + SQL · Lesson 1

Employees Same Salary

The Problem

Find salary values that more than one employee shares — using GROUP BY and HAVING.

The Query

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

salary num_employees ------ ------------- 50000 3

How it Works

GROUP BY salary groups rows by salary; HAVING COUNT(*) > 1 keeps only salaries shared by more than one employee.

Summary

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

\n