Explain cross join or cartesian product in sql?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by anusha kadimi

    The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join.

Related Questions

Please Login or Register to leave a response.

Related Questions

Mssql Interview Questions

What is MSSQL?

MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

Mssql Interview Questions

What is SQL server agent and what are the two modes of authentication in SQL Server?

SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

Mssql Interview Questions

What is SQL Profiler?

It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..