Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Below query is a which type of join?
Select * From employee_master,project_master;
on 11/27/2013 | Category:
Sql Server Interview questions
| Views: 1605 |
Select from following answers:
Above query is a Cross join,it is applied on more than one but different tables.It produces the Cartesian product.
So, Cross join, as the name implies,it produces rows which combine each row from the 1st table with each row from the 2nd table. As i also said that,cross join is applied on more than 1 but different table. and in the above query employee_master and project_master are the 2 different tables.
We can also write such query as:
Select * From employee_master cross join project_master;
Suppose,employee_master is having 5 rows and project_master is having 5 rows,then cross join will produce 25 rows meaning that 1st table multiplied by the number of rows in the 2nd table.
Show Correct Answer
Many Interviews |
< Previous :
What will be the output of below query? Select ...
Next > :
When does below error occur? The GridView ' ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
When does below error occur? The GridView 'grid_view_employee_d ...
How to Concatnate 2 column values to make one column value in SQL-Serv ...
How to Concat 2 Column values in MySQL?
How many ways to remove Last character from String in Dot Net?
What will be the order of null values in below query? Create table ...
What will be the output of the below query? select ISNUMERIC('123 ...
How many ways we can break statements into new lines in Dot Net?
What is an Alternative way of getting Distinct or Unique records in SQ ...
Latest Interview Questions
Which processes implemented sandbox solution?
Which of the following files/programs are not removed by the uninstall ...
What is compatibility level of SQL server 2012?
DBCC SHRINKDATABASE (UserDB, 10); What is the unit of second paramet ...
We can configure individuals to be alerted about sql server agent jobs ...
Which of the following built in tool allows you to changes services ac ...
Which of the following is FALSE regarding the tempdb database?
We can RECOMPILE a stored procedure in SQL server. Which of the follow ...