What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
Answer Posted / prangya mishra
joins are used for retreiving the information from multiple
tables at a time & presenting it.
we have 5 different types of joins
1.Equi join
2.Non-Equi join
3.Self join
4.Cartesian join
5.outer join
Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Explain encryption of entire databases without the need for application changes in sql server 2008?
What are the advantages of sql stored procedure?
What are types of scd? : sql server analysis services, ssas
Tell me what is difference between clustered and non clustered index?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to convert numeric expression data types by assignment operations?
What is indexing in sql server with example?
What are the five major components of a dbms?
What is difference between clustered and non clustered index?
What is coalesce and check constraint in sql server?
Is a primary key unique?
Explain what is lock escalation?
What language is sql server written in?
What are Spatial data types in SQL Server 2008
What is the default fill factor value?