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
9574 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 default schema in mysql?

877

What are the advantages of mysql?

936

What data structure does mysql use?

947

What is field in mysql?

864

What are date and time data types in mysql?

957

How do I stop a mysql command?

923

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

864

Can we store pdf files in mysql?

917

How many groups of data types?

930

What is the latest version of mysql?

932

How do I find my mysql username and password?

920

Is mysql workbench a dbms?

956

How does mysql store dates?

880

What does innodb stand for?

927

What is an index? How can an index be declared in mysql?

835