What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
Answer Posted / veeresh kethari
1.Inner join:All the matched records from the both tables.
2.Left outer join: All the matched records from the both
tables and unmatched records from the left table.
3.Right outer join:All the matched records from the both
tables and unmatched records from the right table.
4.Self join:Joining the table itself.
5.Cross join:Cross join will give u the Cartesian product
from the 2 tables,it won't allow 'where' clause.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to delete multiple rows with one delete statement in ms sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
Can we deploy SSRS reports on our personal website?
What is difference between unique and primary key?
How many servers can we create in a single subscription?
What happens to a statement batch if there is a compilation error?
What is the use of group by clause?
Explain triggers in sql?
Can we use pragma autonomous_transaction in trigger?
What xml support does the sql server extend?
Mention the command used to rename the database.
What is compression - row-level and page-level compression?
how many bits ip address consist of? : Sql server database administration
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What does man by sql wildcard characters in sql server?