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 / 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
Is mongodb faster than mysql?
What is foreign key in mysql?
What are the different data types in mysql?
What is a mysql view?
What is difference between mysqli and pdo?
What is mysqli_result?
How to load a csv file into a table
How many rows can mysql hold?
How to validate email addresses in mysql?
What are the purposes of using enum and set data types?
If we use sum function in mysql, does it return sum of that row or for that column?
What is the function of myisamchk?
How do you restart mysql?
What are the 3 main types of search queries?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?