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
Ways to improve the performance of a SQL Azure Database?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the dbcc command and why is it used?
Why people hate cursor?
What are the key configuration files for sql server reporting services ?
Where is localdb stored?
What is factless fact table? : sql server analysis services, ssas
What is a self join in sql server?
What is the difference between an index and a unique index?
What is a trigger in sql server?
How to write character string constants or literals in ms sql server?
Does partitioning help performance?
What is the contrast between sql and mysql?
What is a periodical index?