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


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: