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
- 63349 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
Tell me when is the update_statistics command used?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are entities and relationships?
When would you use sql joins?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What do you understand by user-defined function in the sql server?
How to deploy the Report?
How does index makes search faster?
what is package and it uses and how can u call a package
How can you stop stored procedures from recompiling?
What is query optimizer in sql server?
Can you explain what is indexed view? How to create it?
How many types of local tables are there in sql server?
What is the name of reporting services config file and what’s it’s used for?
What are the advantages to use stored procedures?
