explain different types of jions with examples briefly?
Answer Posted / vijay
The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database
Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join
3.Cross Join
4.Self Join
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Explain having clause?
What is mapping schema?
Explain microsoft sql server functions?
What is RMS migrations?
How do you Implement SSIS Packages in your Project?
What are the five major components of a dbms?
What is auditing in sql server?
What are the components of sql server service broker?
How can sql server instances be hidden?
Can you type more than one query in the query editor screen at the same time?
Why variables called the most powerful component of ssis?
What is self contained multi valued query?
List the different normalization forms?
Which are new data types introduced in sql server 2008?
Define inner join in sql server joins?