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 are the two authentication modes in sql server?
How to run queries with sql server management studio express?
write coding for importing sql data into a word excel...
What is the need for indexing?
How to update a field in SQL after ALTERING a row?
what are acid properties? : Sql server database administration
What should be the fill factor for indexes created on tables? : sql server database administration
How to Debug a Stored Procedure?
How will you go about resolving deadlocks?
How retrieve field names from the table in SQL through JAVA code?
Write a SQL command to insert and update only a particular field?
What is service broker? : sql server database administration
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)