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

Tell us something about heap tables?

990

Is mysql from oracle?

969

What is query log in mysql?

982

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2122

What is mysqlcommand?

1006

How do I install mysql on windows 10 64 bit?

914

What is the storage engine for mysql?

960

What is username in mysql?

897

How do I show all mysql databases?

965

What is mysql connector used for?

946

How to use case expression?

955

What is heap table in mysql?

973

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

930

If we use sum function in mysql, does it return sum of that row or for that column?

986

explain GROUPBY & HAVING clause with examples.

2292