SELECT sitename, COUNT(*) AS NumOccurrences 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 / bashi

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

Answer Posted / bashi

SELECT sitename, COUNT(*) AS NumOccurrences
FROM tbl_sites
GROUP BY sitename HAVING COUNT(*) > 1

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between sql and mysql and oracle?

899

What is meant by sharding?

944

What is the innodb in mysql?

1049

What is the use of count function in mysql?

1036

Why we use mysql workbench?

914

What is the use of pdo?

958

How can I create a database in mysql?

878

How do I install and use mysql?

954

What is mysqli_free_result?

908

How to determine the location of the data directory?

970

Is mysqli deprecated?

968

How do we use % when performing a search query?

925

What are ddl statements in mysql?

1070

What ascii 31?

968

What are the difference between and myisam and innodb?

1034