How to use count function in mysql?
No Answer is Posted For this Question
Be the First to Post Answer
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?
What is delimiter in mysql stored procedure?
How to check server status with 'mysqladmin'?
Is mysql a backend?
What is the datatype of image in mysql?
How many ways we can retrieve the date in result set of mysql using php?
How does limit work in mysql?
What is table level locking in mysql?
How triggers can be used in mysql?
What is 'mysqldump'?
What is difference between mysql and mysql server?
How many rows mysql can handle?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)