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 turn a list into a table?
what are local and global variables and their differences? : Sql dba
What does pragma mean?
What programs use sql?
Is it possible to create startup or shutdown trigger for on-schema?
What is trigger point?
What does fetching a cursor do?
What is sql exception?
what are the advantages of sql ? : Sql dba
What are the most important characteristics of pl/sql?
When are we going to use truncate and delete?
Explian rowid, rownum? What are the psoducolumns we have?
what is meant by urlencode and urldocode? : Sql dba
How do I restart sql?
Mention what is the plv (pl/vision) package offers?