Interested to Buy Any Domain ? << Click Here >> for more details...
What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
- 2 Answers
- 6013 Views
- Apollo, I also Faced
- E-Mail Answers
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
Should you normalize audio?
What is filter index?
What Is Rdbms?
What is the maximum length of an alert name?
What is coalesce in sql server?
What are the two authentication modes in sql server?
What are tables in sql server?
How can we improve performance by using SQL Server profiler?
Explain transaction server consistency?
What are the characteristics of modern DBMS?
What is the synonym of join?
Explain what is the use of custom fields in report?
What is difference between cte and view?
How to rebuild the master database?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
