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 |
diff b/w function and procedure?
how to retrieve the top 2 salaried persons from a database?
What is rtm stands for?
how many no of table can be join in a sql query.
Which is better join or subquery?
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
Delete the emps whose salaries are lowest sals of their own dept.
What is sql and explain its components?
What plvcmt and plvrb does in pl/sql?
Wat is SGA ?
what are the 'mysql' command line arguments? : Sql dba
what is the cursor and use of cursor in pl/sql ?
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)