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
What are the different types of lock modes in sql server 2000?
What is query processing?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is database dimension? : sql server analysis services, ssas
When we should use and scope of @@identity?
What is meant by indexing files?
What is the maximum size of a dimension? : sql server analysis services, ssas
What are trace flags?
What are the indexes in sql server?
can we have a nested transaction? : Sql server database administration
What are scalar functions in sql?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How do I view a stored procedure in sql server?
Describe in brief authentication modes in sql server.