Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
- 0 Answers
- 741 Views
- I also Faced
- E-Mail Answers
What is the difference between truncate and delete?
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
Where the database is stored in mysql?
How to convert character strings to numeric values?
What is default schema in mysql?
How to calculate the difference between two time values?
List the different types of normalization?
How we can see all indexes defined for a table in mysql?
what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage
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?
How do you know if your mysql server is alive?
What is mysqlcheck do?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
