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
What is Extended user-defined?
What is the fastest way to permanently delete a 1 million row table named customers?
Explain primary key, foreign key and unique key?
How you can add messages to the nt event log from within a stored procedure?
Mention the different types of triggers?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is cross join in sql server joins?
can SSRS reports Cache results?
How to sort the query output with order by clauses in ms sql server?
Write a SQL query to delete a table?
What is scheduled job and how to create it?
what is isolation level at dead lock?
Define primary key?
What are secondary xml indexes?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?