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?
Answer Posted / thilip
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Is mysql a server?
Write a query to create a database and a table?
How many rows can be inserted in mysql at a time?
How to check if a record exists in a mysql database php?
What is indexing in mysql?
How does mysql store data?
How to find second highest salary from a table?
What is append query?
How does mysql store dates?
What is required to create mysql database?
What port is mysql running on?
How do you rename a table in mysql?
Why do gaps in sequences occur?
What does mysql flush tables do?
Can we rollback truncate in mysql?