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
Explain what is the use of custom fields in report?
What is a result set object returned by mssql_query()?
What is difference between table aliases and column aliases? Do they affect performance?
Difference between report and query parameter.
How to create an multi-statement table-valued function?
What is hot add cpu in sql server 2008?
How to create an inline table-valued function?
How to delete existing triggers using "drop trigger"?
What is difference between Datepart() and Datename() in SqlServer?
What is a coalesce function?
What is the sql server 2000 version number?
What is transaction server distributed transaction?
What is SubQuery in SQL Server 2008
What is the maximum size of a row in sql server?
What is blocking?