What is the difference between cross join and Full outer
join?
Answer / soma shaw
A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.
| Is This Answer Correct ? | 18 Yes | 0 No |
What is the need for group functions in sql?
What is the distinction amongst delete and truncate?
Can you explain what are commit and rollback in sql?
What is sql server english query?
What is a trigger? Why we need it?
What are three SQL keywords used to change or set someone?s permissions?
What Are Three Rules to UseĀ UNION IN SQL SERVER
What is an example of a foreign key?
Can we insert data into a view?
difference between Clustered index and non clustered index ?
How to transfer data from a cursor to variables with a "fetch" statement?
Explain few of the new features of sql server 2008 management studio
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)