MySQL Select the rows having same column value

Question

I need to obtain the rows which having same column value from the following table, I tried it the following way, but it gives me a single row only.

select *
from employee e
group by e.empsalary
having count(e.empsalary) > 1

Table employee

Please suggest me a way.

Answer 1

You should be able to accomplish this by joining the table to itself:

SELECT
    a.*
FROM
    employee a
    JOIN employee b
        ON a.empsalary = b.empsalary
        AND a.empid != b.empid