Answer Posted / 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 View All Answers
what are all the common sql function? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Is primary key clustered index?
how to escape special characters in sql statements? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
how to start mysql server? : Sql dba
Is inner join faster than left join?
what are aggregate and scalar functions? : Sql dba
What is your daily office routine?
what is schema? : Sql dba
Can we rollback truncate?
Is primary key always clustered index?
Does group by remove duplicates?
Do we need to rebuild index after truncate?
Can delete statement be rollbacked?
