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
What is back end and front end?
Explain the difference between procedure and function in mysql?
What are the disadvantages of stored procedures?
How to calculate the difference between two dates?
How do I connect to mysql database?
What is append query?
change column name and make a unique column so we get no dupes.
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How to dump a table from a database.
How do I tune a mysql query?
how to display nth highest salary from a table in a mysql query? : Mysql dba
Is number a datatype in mysql?
What is the difference between having and where clause in mysql? Explain
What is mysql community server?
How to create a new table in mysql?