Why cross join is used?



Why cross join is used?..

Answer / Nagender Choudhary

A cross join (also known as a Cartesian product) returns all possible combinations of rows from input tables. It is useful when you want to compare every row in one table with every row in another table, regardless of any matching conditions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

diff b/w function and procedure?

9 Answers   iFlex,


how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,


What is rtm stands for?

1 Answers  


how many no of table can be join in a sql query.

4 Answers  


Which is better join or subquery?

1 Answers  


What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,


Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  


What is sql and explain its components?

1 Answers  


What plvcmt and plvrb does in pl/sql?

1 Answers  


Wat is SGA ?

3 Answers   ABB,


what are the 'mysql' command line arguments? : Sql dba

1 Answers  


what is the cursor and use of cursor in pl/sql ?

4 Answers  


Categories