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

What is back end and front end?

905

Explain the difference between procedure and function in mysql?

992

What are the disadvantages of stored procedures?

979

How to calculate the difference between two dates?

1060

How do I connect to mysql database?

1041

What is append query?

912

change column name and make a unique column so we get no dupes.

984

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2227

How to dump a table from a database.

1019

How do I tune a mysql query?

890

how to display nth highest salary from a table in a mysql query? : Mysql dba

1065

Is number a datatype in mysql?

944

What is the difference between having and where clause in mysql? Explain

1018

What is mysql community server?

930

How to create a new table in mysql?

1046