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?
Answers were Sorted based on User's Feedback
Answer / dinesh goyal, scorpio
select sitename,count(sitename) as total_sites from
tbl_sites group by sitename having (count(sitename)>1)
Is This Answer Correct ? | 22 Yes | 1 No |
Answer / bashi
SELECT sitename, COUNT(*) AS NumOccurrences
FROM tbl_sites
GROUP BY sitename HAVING COUNT(*) > 1
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sriram
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename
Is This Answer Correct ? | 5 Yes | 7 No |
Answer / thilip
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename
Is This Answer Correct ? | 2 Yes | 5 No |
What is the difference between sql and mysql and oracle?
What is the limit of mysql database?
what is the advantage of left outer join?
What is mysql cursor?
What is an example of a delimiter?
What language is used in mysql?
How are mysql timestamps seen to a user?
How can I connect mysql database?
What is cast in mysql?
What is the usage of ENUMs in MySQL?
Is mysql a server or database?
What does mysql_fetch_assoc do?