What is the difference between cross join and Full outer
join?
- 1 Answers
- 6916 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 |
What is the difference between sdf and mdf?
If the job running very slow what is the action you do
How do I view a stored procedure in sql server?
What is an extended Stored Procedure?
Why do we use stored procedures in sql server?
How important do you consider cursors or while loops for a transactional database?
Why olap is used?
What are the differences between decimal and float in ms sql server?
What are different types of database indexes?
Delete duplicate rows without using rowid.
What are the character string functions supported by sql server 2005?
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
-
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)
