How many types of Joins in SQL Server 2005?
Answer Posted / prasanna
1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to create function without parameter in sql server?
Why is the need for data conversion transformations?
What is the difference between Triggers and Stored Procedure?
what authentication modes does sql server support? : Sql server database administration
What is use of @@ spid in sql server?
Can we join two tables without primary key?
Explain logical operators in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are “unrepeatable reads”?
How will you find out if there are expensive SQL statements running or not?
What are the different SQL Server Versions you have worked on?
How to concatenate two strings in SQL Server.
What is the difference between count and distinct count?
What do you mean by tablesample?
What is meant by indexing?