What are joins..how many types of joins are there?
Answer Posted / shree
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
Is This Answer Correct ? | 47 Yes | 16 No |
Post New Answer View All Answers
What are ddl statements in oracle?
How to rename an existing table?
What is data file?
How different is ms access and oracle?
What are data pump export and import modes?
Explain the use of indexes option in imp command.
What is oracle latest version?
How to use like conditions in oracle?
Is truncate autocommit in oracle?
Which is faster join or subquery in oracle?
What is difference between truncate and delete?
How to grant create session privilege to a user in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to define an anonymous procedure with variables?
How to assign values to data fields in record variables?