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,

---

about foregine

2 Answers  

---

Where is the mysql database stored?

0 Answers  

---

What is the difference between SQL and SQL Server?

3 Answers   Cognizant, HCL,

---

Can varchar be primary key?

0 Answers  

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  

---

What is striped backup

0 Answers   Cap Gemini,

---

How to list or view all databases from the mysql server.

0 Answers  

---

Where MyISAM table will be stored and also give their formats of storage?

0 Answers  

---

How do I connect to a mysql database?

0 Answers  

---

What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers  

---

What is meant by mysql database?

1 Answers  

---