What is a join and their types?
Answer Posted / s.chithiravelu
Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.
Various Types of Joins:
Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do you understand by hotfixes and patches in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are .mdf files?
How to recompile stored procedure at run time?
What are three major types of constraints?
How to send a ssrs report from ssis?
Do you know nested transaction?
What's new in sql management studio for sql server? : sql server management studio
What is the sql case statement used for? Explain with an example?
How to concatenate two binary strings together?
Do you know what is similarity and difference between truncate and delete in sql?
What is query and its types?
What is the stuff?
Explain sql server authentication modes?
how would you store your query in an SSRS report or a Database server?