I’m learning Mysql, a newbie.
First I wrote:
Select name, count(*) From Emp Group By name;
and the code was successful.
After that, I added to the code it became:
Select * From Emp Where (Select name, count(*) From Emp Group By name) > 1;
and I get an error message too many values.
How to fix that?
To get all the information of the employees that have the same name, you can do folowing
Select e1.* From Emp e1 INNER JOIN (Select DISTINCT name From Emp Group By name having count(name) > 1) e2 ON e2.name = e1,name