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 / thilip

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

Answer Posted / thilip

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

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

In mysql, what is the default storage engine?

1010

What is the latest version of php and mysql?

1215

How to run a sql statement?

1038

What is definer in mysql trigger?

915

Explain about the architecture of MYSQL?

981

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1365

I want to start and stop mysql on windows? How do I do that?

1064

What is mysql uuid?

927

How do I start mysql in linux?

911

How do I run a query in mysql?

946

What are features of mysql?

892

What is pdo mysql?

948

What is difference between mysql and mysql server?

997

What is blob storage?

986

How triggers can be used in mysql?

1017