Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
If cross-join is having WHERE CLAUSE,then which type of join it will be called?
on 11/28/2013 | Category:
Sql Server Interview questions
| Views: 3480 |
Select from following answers:
All of the above.
It will be called as Inner Join.Because we know that,Cross Join does not contain WHERE CLAUSE.
Select * from employee_master,project_master; ->Cross Join
Select * from employee_master,project_master where condition ->Inner Join.
Show Correct Answer
Many Interviews |
< Previous :
If we write below query,then what will happen? ...
Next > :
Below query is which type of join in sql-server? ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
Below query is which type of join in sql-server? Select * from empl ...
What is the max length of Nvarchar data-type?
Which Data-Type is used for storing Multilingual-Languages other than ...
What will be the output of below query? Select Replicate('visha ...
How many ways of getting Last records in SQL-Server?
How to get Last record in MySQL?
What do we mean by self-join and cross-join?
What will be the Error after executing below query? select * from e ...
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 ...