| Back to Questions Page | | Question |
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? |
Rank |
Answer Posted By | |
Interview Question Submitted By :: Pranab | |
I also faced this Question!! |
© ALL Interview .com | | Answer |
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename  |
0 | Thilip
| | |
| | | Answer |
select sitename,count(sitename) as total_sites from
tbl_sites group by sitename having (count(sitename)>1) |
0 | Dinesh Goyal, Scorpio
| | |
| | | Answer |
SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename |
0 | Sriram
| | |
| | |
| | | |
| |
|
Back to Questions Page |
|
Site Map
