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 happens if a table has one column defined as TIMESTAMP?
Explain the architecture models of SQL Server?
How to declare variable in mysql trigger?
What is pragma autonomous_transaction?
What is the difference between timestamp and datetime in mysql?
How can we find the number of rows in a table using MySQL?
What is the purpose of using timestamp data type?
What is a mysql model?
What is 1nf 2nf 3nf?
What is the difference between a Table and a View?
How many columns can a table have?
How can you export the table as an xml file in mysql?