b).How to find the duplicate value in mysql

 

 select Name,count(*) from emp  
 group by Name
 having count(*)>1 ;