How to find all the employees having same salary #shorts #sql #coding #sqlqueries #dataanalytics

How to find all the employees having same salary #shorts #sql #coding #sqlqueries #dataanalytics #youtubeshorts #programming

[SwissGuru]

WARNING if more than two employees have the same salary, the query can return duplicates. You should add a distinct

[alexcerny]

WITH single_sal AS
(SELECT DISTINCT Salary
FROM Employee)
SELECT *
FROM Employee
WHERE Salary NOT IN single_sal;

[chennakesavasreeramadas]

Select * from table
Group by salary
Having count salary>1

[himanshunandan]

Can we use the rank or dense rank function as if the salary will be same the rank will be assigned same.

[vivekjoshi]

The two instances thing
FROM employee E1, employee E2
Is this possible in PostgreSQL?

[archishmanchoudhury]

Ok...but what type of query is this known as?

[billyhagood]

Bruh never heard of "group by" 😂😂

[howhello]

Lol, this won't work properly if 3 or more persons have the same salary. It gonna print lots of duplicate.