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 to insert html code into mysql database using php?

0 Answers  

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  

---

What are the different mysql database engines?

0 Answers  

---

What is blob and text in mysql?

0 Answers  

---

---

What is timestamp in mysql?

0 Answers  

---

How do I disable mysql?

0 Answers  

---

What is mysql port?

0 Answers  

---

How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  

---

How to run a sql statement?

0 Answers  

---

what is the main difference between myisam and innodb

2 Answers   Wipro,

---

What are the types of queries?

0 Answers  

---