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
How to delete existing triggers using "drop trigger"?
How do I start sql server 2017?
What is a partition function in sql server?
What is a non equi join?
Can we add an identity column to decimal datatype?
What are the steps you should follow to start sql server in single-user mode?
What is clustered index
Explain about merge replications?
How to start sql server browser service?
What are the diifferences between the ms sql server vs mysql?
Why we need sql server?
What are the commands used in DCL?
Can primary key be a foreign key?
Is oracle faster than sql server?
What are the differences between having and where clause.