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,

---

Why do we use mysql?

0 Answers  

---

Restore database (or database table) from backup.

0 Answers  

---

Is there a free mysql?

0 Answers  

---

Is SET Command is SQL Statement..?

4 Answers   BitWise,

---

What is general log in mysql?

0 Answers  

---

What is the difference between char and varchar?

0 Answers  

---

what programming language which is used for testing and developement in sql?

3 Answers  

---

What are the differences between char and varchar?

0 Answers  

---

What are procedures in mysql? Explain

0 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

How can we convert between Unix & MySQL timestamps?

0 Answers  

---