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
- 6188 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
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is difference between count (*) and count column?
Explain sql server authentication modes?
Why we use the openxml clause?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
what is database replicaion? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is database dimension? : sql server analysis services, ssas
How to connect Azure federated root database and apply federation in entity framework?
How to create a view with data from multiple tables?
what do you understand by change data capture?
How to skip remaining statements in a loop block using continue statements?
How to compare the top two records using sql?
What are subqueries in sql server? Explain its properties.
