1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

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 limit work in mysql?

1 Answers  

How we can get the current date in mysql?

1 Answers  

Explain the difference between BOOL, TINYINT and BIT?

1 Answers  

What is the use of indexing table?

2 Answers  

What is the default port number of mysql?

1 Answers  

Can you save your connection settings to a conf file?

1 Answers  

Is mysql a server?

1 Answers  

How to represent ENUMs and SETs internally?

1 Answers  

If we use sum function in mysql, does it return sum of that row or for that column?

1 Answers  

What is user in mysql?

1 Answers  

What are procedures in mysql? Explain

1 Answers  

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

For more MySQL Interview Questions Click Here
Categories