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 are the disadvantages of stored procedures?
How to decrement dates by 1 in mysql?
What is mysql data directory?
what is database white box testing? : Mysql dba
Where is the mysql database stored?
How to extract a unit value from a date and time?
How do I edit a table in mysql workbench?
What is row?
How do I change the max connections in mysql?
Why phpmyadmin is used for mysql?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
Is sqlite faster than mysql?
What is innodb_buffer_pool_size?
How to find second highest salary from a table?
How do I install mysql workbench?