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

How do I install mysql workbench?

950

How to make a column bigger and delete unique from table.

1036

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1429

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3280

What is normalization and list the different types of normalization?

993

Write a query to count the number of rows of a table in mysql.

989

What is the current root password of mysql?

966

What is a user defined variable?

955

Can mysql scale horizontally?

1034

Can a table have multiple primary keys?

950

What is memory table?

960

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1179

What is mysql database used for?

1090

Does mysql support sequence?

992

Is sql similar to mysql?

953