How many types of Joins in SQL Server 2005?
Answer Posted / abi
Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of keys are there?
What does it mean if @@cursor_row returns a negative number?
What is the difference between upgrade and migration in sql server?
Can a database be shrunk to 0 bytes, if not, why?
What is the difference between count () and rowcount ()?
How to rename databases in ms sql server?
How can windows applications connect to sql servers via odbc?
What are subqueries in sql server?
Mention the different types of replication in sql server.
How do I run a trace in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How you can find out if an index is useful to the optimizer?
What is forward - only cursors / read only cursor?
What is onf in normalization form?
What are the essential components of sql server service broker?