What is a join?Explain the different types of joins?
Answer Posted / pratap
Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Equi join(i.e. Inner join)
2. self join
3. left join
4. right join
5. outer join
Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
How do I truncate a sql log file?
What is difference between left and right outer join?
What does plv msg allows you to do?
Explain how exception handling is done in advance pl/sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
How do I add a primary key to a table?
what is myisam? : Sql dba
Why schema is used in sql?
Can triggers stop a dml statement from executing on a table?
What is trigger price?
What is clustered index in sql?
What is thread join () in threading?
What is delimiter in pl sql?
What is aggregate function in sql?
What is the difference between sql and isql*plus?