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
- 9569 Views
- Afixi, GE, I also Faced
- E-Mail Answers
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 happens if null values are involved in expressions?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What is the difference between mysql and oracle?
How do I edit a table in mysql workbench?
Which is better mysql or mssql?
How to convert character strings to dates?
Why mysql is used with php?
What is the use of mysql workbench?
Write a query to count the number of rows of a table in mysql.
What are date and time data types?
Why we use mysql database?
How large can a mysql database become?
How do I enable mysqli extension?
What are the disadvantages of mysql?
How can I create table in mysql?
