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 sql server query analyzer?
Explain having clause and where clause?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are sparse columns?
What are scheduled tasks in sql server?
How will you make an attribute not process? : sql server analysis services, ssas
Why do we need different type of parameter?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;
How many databases instances are there in sql server 2000?
What are cursors?
What is 1nf normalization form?
Oracle (3253)
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)