Interested to Buy Any Domain ? << Click Here >> for more details...
What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....
- 9 Answers
- 63692 Views
- DELL, i Tech, Infosys, Siemens, TCS, I also Faced
- E-Mail Answers
Answer Posted / prangya mishra
joins are used for retreiving the information from multiple
tables at a time & presenting it.
we have 5 different types of joins
1.Equi join
2.Non-Equi join
3.Self join
4.Cartesian join
5.outer join
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
what is the sql equivaent of the dataset relation object ?
How do I find the query plan in sql server?
How to display a past time in days, hours and minutes?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the benefits and tasks of object explorer? : sql server management studio
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is the syntax for encrypting a column in SQL Server?
What is the purpose of the model database?
How many columns can we include on clustered index ?
Define the one-to-one relationship while designing tables.
what are defaults? : Sql server database administration
What are filegroups in sql server?
How to get @@error and @@rowcount at the same time?
How many databases Microsoft SQL server provides?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
