Query to get repeated rows
This query is to get repeaed details.for example a student table contains column named StudentName
StudentName ->Arun,Sony,Anu,Sony,anu,akhil,anu
I want to get the result as
Sony 2
anu 3
Select Name,count(*) from Student group by studentname having count(*)>1