What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
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
What is database replication? What are the different types of replication you can set up in sql server?
Can we call stored procedure in trigger?
Do you know what are various aggregate functions that are available?
Can you edit the .rdl code associated with a linked report?
How to recover from sql injection? : sql server security
Is it possible to have clustered index on separate drive from original table location?
What is the importance of a recovery model?
How to enable tcp/ip protocol on a sql server?
What do you understand by triggers and mention the different types of it?
What are the 10 characteristics of data quality?
What are system databases in ms sql server?
What are the differences between clustered and non-clustered index?
What the class forname () does?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is TDS(Tabular Data Stream) Gateway?