How to solve errors in MySql subquery

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?

>Solution :

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 = e1,name

Leave a Reply