What are the different types of joins and what does each do?
Answer Posted / sachin patil
Diff types of join
1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which is the best place or learning center for MS SQL?????In Bangladesh?????
how many no of arguments can be passed in procedures and functions
How to create an index on an existing table in ms sql server?
Explain various On-Delete options in a DB table. Which is the default option?
What are the dmvs?
How to drop existing views from a database in ms sql server?
how to do partition in sqlserver
What are the different types of triggers in SQL SERVER?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Where the sql logs gets stored? : sql server database administration
how you can configure a running aggregate in SSRS?
What is function of CUBE ?
How to get the definition of a stored procedure back?
What is data block and how to define data block size?
How to use old values to define new values in update statements in ms sql server?