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
9766 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 is mysqli_free_result?

903

What is sql vs mysql?

1019

What is csv?

952

How to delete the repeated records from a table?

979

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3979

What is the latest mysql?

957

What mysql -u john -p command does?

975

How many concurrent queries can mysql handle?

896

What is longblob in mysql?

968

What is the difference between truncate and delete?

1195

Is mysql a framework?

928

How do I import database through command line?

1009

What are date and time data types?

1000

What is 'mysqlshow'?

1061

How do I install mysql?

911