Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows
Answers were Sorted based on User's Feedback
Answer / msy
Cartesion result of A and B will be 0 rows selected.
| Is This Answer Correct ? | 3 Yes | 1 No |
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
What is full text indexing in mysql?
What are queries used for?
How do I clear the command in mysql?
How to get the number of rows selected or affected by a sql statement?
What is append query?
How can a user get the current SQL version?
How do I show all mysql databases?
What are the advantages/disadvantages of mysql and php?
What is the current mysql version?
how to find max salary from the database
Is mysql a scripting language?
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)