What are the different types of joins and what does each do?
Answer Posted / sachin patil
Diff types of join
1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we need different type of parameter?
What is #temp and @table variable in SQL server?
What do you understand by a view?
Where is my database stored on the hard disk in ms sql server?
What are the steps to insert a table?
How can you list all the columns in a database?
How can you stop stored procedures from recompiling?
When is the use of update_statistics command?
What are the restrictions that views have to follow? : SQL Server Architecture
What are trace files?
What is nolock hint in sql server 2008
What is the difference between a local and a global temporary table?
Write a SQL command to insert and update only a particular field?
What is difference between views and stored procedures?
What is a result set object returned by odbc_exec()?