select sitename,count(sitename) as total_sites from tbl

The table tbl_sites contains the following data:
-----------------------------------------------------
Userid sitename country
------------------------------------------------------
1 sureshbabu indian
2 PHPprogrammer andhra
3 PHP.net usa
4 PHPtalk.com germany
5 MySQL.com usa
6 sureshbabu canada
7 PHPbuddy.com pakistan
8. PHPtalk.com austria
9. PHPfreaks.com sourthafrica
10. PHPsupport.net russia
11. sureshbabu australia
12. sureshbabu nepal
13. PHPtalk.com italy
Write a select query that will displayed the duplicated
site name and how many times it is duplicated?

Question Posted / dinesh goyal, scorpio

4 Answers
9575 Views
Afixi, GE, I also Faced
E-Mail Answers

Answer Posted / dinesh goyal, scorpio

select sitename,count(sitename) as total_sites from
tbl_sites group by sitename having (count(sitename)>1)

Is This Answer Correct ?

22 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I completely remove mysql from windows?

916

What are the 'mysql' command line arguments?

949

What is a result set object?

905

How to delete a table.

872

How large can a mysql database become?

918

How to return query output in xml format?

983

What is the command used to create a database using php and mysql?

1089

How to delete an existing column in a table?

887

What is query log in mysql?

902

What is a delimiter in mysql?

936

What is a data directory?

877

What is select query in mysql?

860

What is deterministic in mysql?

927

Is mysql same as sql?

843

Difference between CHAR and VARCHAR?

1023