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
- 9910 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 data structure does mysql use?
What are all the Common SQL Function?
How to create table show example
What is the current root password of mysql?
Which storage engine is best in mysql?
Why do we use mysql?
Why mongodb is faster than mysql?
What is slow query log in mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
What is insert query in mysql?
How can we optimize stored procedure?
What is mysql gpl?
How to enter binary numbers in sql statements?
What are slow queries?
What is the difference between procedure and function in mysql?
