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
What are the difference between “where” and “having” clause in sql server?
What happens if null values are involved in comparison operations?
What is difference between rownum and rowid?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is a field in a table?
What is logshipping and its purpose?
How to create an multi-statement table-valued function?
Is null vs coalesce?
How to enable/disable indexes?
What is the security principal at the server level that represents your session?
What is difference between inner join and join?
Define model database?
What are the diifferences between the ms sql server vs mysql?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is data set in report?