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 / sriram
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename
Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is difference between mysql_connect and mysql_pconnect?
What is the purpose of using timestamp data type?
What is the usage of "i-am-a-dummy" flag in mysql?
Why do we use mysql?
What is the difference between unix timestamps and mysql timestamps?
Is mysql and sql are same?
What do we use to remove duplicate records while fetching a data in mysql ?
How to Set a root password if there is on root password.
Which is better sqlite or mysql?
Is mysql a nosql database?
What is the function of myisamchk?
Is mysql a programming language?
How to check if value already exists in mysql database in php?
Write a query to retrieve a hundred books starting from 20th.
How can you retrieve a portion of any column value by using a select query?