SELECT sitename,COUNT(sitename) 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 / sriram

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

Answer Posted / sriram

SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename

Is This Answer Correct ?

5 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I edit a trigger in mysql?

894

Is mysql case-sensitive?

896

How we can get the current date in mysql?

960

What are the functions in mysql?

957

How does mysql store binary data?

969

What is the purpose of -> in the mysql terminal?

1127

What does mysqli stand for?

940

Why mysql is open source?

925

Why we use mysql database?

934

What is 'mysqlcheck'?

1027

What are the 'mysql' command line arguments?

1016

What is the difference between a heap table and temporary table?

941

Is mysql open source?

945

How do I rename a procedure?

885

How do you say mysql?

902