What is the joins and how many types of Joins in sql server
a diffrentiate ever one give a suaitable query
- 2 Answers
- 5532 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
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Tell me the difference between clustered and non-clustered index?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is an inner join?
What are the different types of replication you can set up in sql server?
What is the meaning of sql server?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is log shipping?
Explain the working of sql privileges?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How many types of built in functions are there in sql server 2012?
What is usually the first word in a sql query?
Explain about unique identifier data type in sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain the steps to use transact-sql cursor?
