The table tbl_sites contains the following data: -----------------------------

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?

Question Posted / pranab

4 Answers
9789 Views
Afixi, GE, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

The table tbl_sites contains the following data: -------------------------------------------------..

Answer / dinesh goyal, scorpio

select sitename,count(sitename) as total_sites from
tbl_sites group by sitename having (count(sitename)>1)

Is This Answer Correct ?

22 Yes

1 No

The table tbl_sites contains the following data: -------------------------------------------------..

Answer / bashi

SELECT sitename, COUNT(*) AS NumOccurrences
FROM tbl_sites
GROUP BY sitename HAVING COUNT(*) > 1

Is This Answer Correct ?

0 Yes

1 No

The table tbl_sites contains the following data: -------------------------------------------------..

Answer / sriram

SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename

Is This Answer Correct ?

5 Yes

7 No

The table tbl_sites contains the following data: -------------------------------------------------..

Answer / thilip

SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename

Is This Answer Correct ?

2 Yes

5 No

Post New Answer

More MySQL Interview Questions

How does mysql clustering work?

0 Answers

What is row level locking?

0 Answers

What is the difference between truncate and delete?

0 Answers DELL,

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 Afixi, GE,

How can you do the fine tunning?

3 Answers ACC,

What is the difference between char and varchar data types?

6 Answers

What is myisam?

0 Answers

What are the differences between char and varchar data types?

0 Answers

what is the difference between gui testing and database testing? : Mysql dba

0 Answers

How do I start mysql manually?