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 is unsigned int in mysql?

0 Answers  

---

What is truncate in mysql?

0 Answers  

---

What does schema mean?

0 Answers  

---

Why do we use views instead of tables?

0 Answers  

---

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

0 Answers  

---

In which year mysql created?

0 Answers  

---

What is DDL in MySQL?

1 Answers  

---

How to get the number of rows selected or affected by a sql statement?

0 Answers  

---

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

0 Answers  

---

How do I find users in mysql?

0 Answers  

---

What is the purpose of using ifnull() function?

0 Answers  

---