What is triggers and how it can be used in mysql?
No Answer is Posted For this Question
Be the First to Post Answer
How can you retrieve a portion of any column value by using a select query?
What is difference between mysql mysqli and pdo?
Can you shard mysql?
Can python connect to mysql?
how to add a new column to an existing table?
What is database engine in mysql?
What is the date format in mysql?
What is full text indexing in mysql?
Why myisam is faster than innodb?
What is difference b/w composit key n primary key and forigion key?
How can I create table in mysql?
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?
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)