What is the difference between cross join and Full outer
join?
- 1 Answers
- 6925 Views
- HP, Standard Bank, I also Faced
- E-Mail Answers
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 |
Explain the advantages of merge replication?
How many ways to create table-valued functions?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
What do you understand by physical_only option in dbcc checkdb?
How will you go about resolving deadlocks?
How to include date and time values in sql statements?
Define right outer join?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Explain what are various ways to enhance the ssrs report?
What are four major operators that can be used to combine conditions on a where clause?
How to execute stored procedure and set temp table in sql server?
What is the difference between deallocate cursor and close cursor?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
