Answer Posted / Pawan Chaubey
"Cross Join or Cartesian Product in SQL returns the result of joining every row from one table with every row from another table. It does not consider any relationship between the tables."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
What is clustered index
What is sql server query analyzer?
List out the different types of locks available in sql server?
What is temporary table in sql server? Why we use temp table?
Can you index views?
Equi join and non equi join is possible with sql server?
What are different types of constraints?
How to rebuild the master database?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the different SQL Server Versions you have worked on?
What are wait types?
Why use identity in sql server?
What is subquery? Explain the properties of a subquery?
Explain “row_number()” in sql server with an example?
