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 text?

0 Answers  

---

How do I download a mysql community server?

0 Answers  

---

How do I make an action query?

0 Answers  

---

How is data stored in mysql?

0 Answers  

---

Can I install mysql on mac?

0 Answers  

---

What is mysql protocol?

0 Answers  

---

How do you prevent MySQL from caching a query?

1 Answers  

---

How internally data stores in MyISAM and INNODB table types?

0 Answers   Zensar,

---

What is a mysql server?

0 Answers  

---

How do you concatenate strings in mysql?

0 Answers  

---

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---