1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain cross join or cartesian product in sql?

Question Posted / bhoopendra singhkhey


Explain cross join or cartesian product in sql?..

Answer / 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

More SQL Server Interview Questions

What is a result set object returned by odbc_exec()?

1 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

What is index in an assignment?

1 Answers  

What is a sub-query? When would you use one?

3 Answers  

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

Do you know what is difference between stored procedure and user defined function?

1 Answers  

Explain indexed view?

1 Answers  

Explain for xml explicit mode?

1 Answers  

What is set nocount on?

1 Answers  

What is a user-defined function in the sql server and what is its advantage?

1 Answers  

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1 Answers  

What is ms sql server reporting services?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories