What are joins, explain all types of joins?
- 1 Answers
- 2401 Views
- Bravura Solutions, I also Faced
- E-Mail Answers
Answer Posted / Shivam Shukla
Joins in SQL allow the combination of rows from two or more tables based on a related column between them. There are several types of joins:
1. Inner Join: Returns only the matching rows from both tables involved in the join.
2. Left (Outer) Join: Returns all the rows from the left table and the matching rows from the right table, if any. If there is no match, null values are used for columns from the right table.
3. Right (Outer) Join: Returns all the rows from the right table and the matching rows from the left table, if any. If there is no match, null values are used for columns from the left table.
4. Full (Outer) Join: Returns all the rows when there is a match in either the left or right table. If there is no match, null values are used for columns from the non-matching table.
5. Cross Join (Cartesian Product): Returns the combination of every row from both tables involved in the join.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to start an oracle instance?
What is oracle latest version?
How to use values from other tables in update statements using oracle?
