Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

RIGHT OUTER JOIN
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

A RIGHT OUTER JOIN in SQL is a type of join that combines rows from two or more tables based on a specified condition and includes all rows from the right (or second) table, regardless of whether there is a match in the left (or first) table. If there is no match, NULL values are filled in for columns from the left table.

Syntax

SELECT * 
FROM table1
RIGHT JOIN table2 
ON table1.column_name = table2.column_name;

Example

Consider we have two tables, students and grades, with information about students and their respective grades:

Now, let's perform a RIGHT OUTER JOIN

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible