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
- 8367 Views
- Afixi, GE, I also Faced
- E-Mail Answers
Answer Posted / bashi
SELECT sitename, COUNT(*) AS NumOccurrences
FROM tbl_sites
GROUP BY sitename HAVING COUNT(*) > 1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to rename an existing column in a table?
How do I find the size of a mysql database?
Create table employee (eno int(2),ename varchar(10)) ?
What is unsigned in mysql?
How you will Show unique records.
How to create trigger in mysql phpmyadmin?
How do I rename a table in mysql workbench?
Does mysql case matter?
What is table level locking in mysql?
How do you determine the location of mysql data directory?
Write a command to list all databases in mysql?
How do I change mysql password?
What is the current version of mysql?
How to enable or disable a row of a table using MySQL in struts?
What is a storage engine?
