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,

---

What are the 5 r's of managing behaviors?

0 Answers  

---

How to display nth highest salary from a table in a mysql query?

0 Answers  

---

How do you create a primary key?

0 Answers  

---

How do you control the max size of a HEAP table?

1 Answers  

---

Explain the difference between primary key and candidate key in mysql?

0 Answers  

---

How can you change the name of any existing table by using the sql statement?

0 Answers  

---

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

---

can you tell what are the different set operations available in mysql? : Mysql dba

0 Answers  

---

How do I create a new database in mysql?

0 Answers  

---

What are the three types of queries?

0 Answers  

---

What is the difference between CHAR and VARCHAR data types?

2 Answers   Ramco,

---