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 to use sql*plus built-in timers?
How does an execution block start and end in pl sql?
What is the use of procedures?
How does postgresql compare to mysql?
How do I run pl sql in sql developer?
which operator is used in query for pattern matching? : Sql dba
Why do we use partitions in sql?
what are date and time data types in mysql? : Sql dba
What is the main difference between sql and pl/sql?
what is meant by urlencode and urldocode? : Sql dba
what are the different index configurations a table can have? : Sql dba
What is an exception in pl/sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Is sql a case sensitive language?
What is snowflake sql?