What is cross join sql?



What is cross join sql?..

Answer / Atul Kumar Tripathi

A CROSS JOIN (also known as a Cartesian product) in SQL returns the combination of all rows from each table that's being joined.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1 Answers  


What is java sql drivermanager?

1 Answers  


What is a native sql query?

1 Answers  


a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,


What is a temporal data type?

1 Answers  


Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  


How do I quit sql?

1 Answers  


Is primary key clustered or nonclustered?

1 Answers  


Can you join views in sql?

1 Answers  


why use cursors?

5 Answers   Oracle,


What is pl/sql table? Why is it used?

1 Answers  


Categories