What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
- 2 Answers
- 5363 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / veeresh kethari
1.Inner join:All the matched records from the both tables.
2.Left outer join: All the matched records from the both
tables and unmatched records from the left table.
3.Right outer join:All the matched records from the both
tables and unmatched records from the right table.
4.Self join:Joining the table itself.
5.Cross join:Cross join will give u the Cartesian product
from the 2 tables,it won't allow 'where' clause.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain filtered indexes benefits?
How are the exceptions handled in sql server programming?
Write down the syntax and an example for create, rename and delete index?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is difference between unique and primary key?
List out a number of the wants to setup a SQL Server failover cluster?
How many databases instances are there in sql server 2000?
How to defragment indexes with alter index ... Reorganize?
Explain the use of containers in ssis and also their types?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What purpose does the model database server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is the impact on other user sessions when creating indexes?
Explain what you mean by 3 tier architecture.
What are tables in sql server?
