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
How can you create and drop view in mysql?
How do I grant privileges to a user in mysql phpmyadmin?
How do you say mysql?
How do I create a mysql database?
all the queries used in sql
Does mysql support nosql?
Is mysql easy to learn?
What is meant by decimal (5,2)?
What is a join in mysql?
How do I find my mysql username and password?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What are the types of database engines available in mysql?
Can I install mysql on mac?
Is there a free mysql?
What is mysql uuid?