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
- 9576 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
Can we use mysql and mysqli together?
What is meant by decimal (5,2)?
Does mysql use t sql?
What is the latest mysql?
How to delete a table.
How does mysql store dates?
How do I know if mysql is running on windows?
How do you determine the location of mysql data directory?
How to use case expression?
How do I edit a trigger in mysql?
Explain the difference between delete and truncate.
How to get current MySQL version?
What is mysqlcheck do?
What is mysql database used for?
How would you get the current date in mysql?
