What are the Different Types of Joins and How do They Work?

Question Posted / hr@tgksolutions.com

1 Answers
1819 Views
I also Faced
E-Mail Answers

What are the Different Types of Joins and How do They Work?..

Using an inner join, records from both tables with matching values are retrieved.
All records from the left table and matched records from the right table are retrieved using a left join, also known as a left outer join. Records from the right table that don't match will be NULL.
All records from the right table and matched records from the left table are retrieved using a right join, also known as a right outer join. Records from the left table that don't match will be NULL.

When there is a match in either the left or right table, records are retrieved using a full join (full outer join). Records from both tables that don't match will be NULL.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

When we will denormalize data?

0 Answers

write a query to retrieve the last day of next month in oracle.

0 Answers

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers 3i Infotech,

What is oracle block? Can two oracle blocks have the same address?

0 Answers

how Data is stored in a file so that Direct Searching can be performed

0 Answers HCL,

What are codd rules?

0 Answers

What do you mean by transparent dbms?

0 Answers

Why do we need database?

0 Answers

What is dbms language?