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 |
wat is mean by normalization?......programing defination i need...(i know basic defination)
what are the different ways to return the rowcount of a table?
What are the different types of normalization?
What happens if null values are involved in datetime operations?
How column data types are determined in a view?
What is 1nf 2nf and 3nf?
Mention the different authentication modes in sql server.
how to delete duplicate rows in sql server2005
7 Answers Cisco, CTS, HCL, IBM,
Differencr Between DELETE and TRUNCATE?
What is @@rowcount in sql?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
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)