Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9914 Views
- Afixi, GE, I also Faced
- E-Mail Answers
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 ddl, dml, and dcl?
Is sqlite faster than mysql?
How do I view a mysql database?
What is federated tables in mysql?
How do I show all mysql databases?
What is database url for mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
How do I start and stop mysql on windows?
What is mysql57?
Write a query to find duplicate rows in table?
How to list or view all databases from the mysql server.
What data type is money?
What are the other commands to know the structure of a table using mysql commands except explain command?
How to make a copy values from one column to another in mysql?
What is mysql routine?
