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
9909 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

What are the purposes of using enum and set data types?

975

How to run a sql statement?

1075

How do you name a table?

933

How to use count function in mysql?

970

Restore database (or database table) from backup.

1071

How do you create a schema?

1013

What is sql in mysql?

1085

What is mysql optimization?

968

Which is better mysql or mssql?

981

Is mysql same as mariadb?

948

How you will Show unique records.

1069

How will you export tables as an xml file in mysql?

969

Is mysql a dbms?

949

Can I use mysql for free?

941

how you will Create a database on the mysql server with unix shell.

1106