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
9623 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 many ways we can we find the current date using MySQL?

5 Answers

What is the current version of mysql?

0 Answers

What are the steps involved in query processing?

0 Answers

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers

why we are join a tow table

1 Answers

What is default password for mysql?

0 Answers

What is mysql procedure?

0 Answers

What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers

What is data types in mysql?

0 Answers

How MySQL Optimizes DISTINCT?

0 Answers

What is striped backup

0 Answers Cap Gemini,

For more MySQL Interview Questions Click Here