Which are joins in SQL? Name the most commonly used SQL joins?

0

SQL joins are used to retrieve data from multiple tables into a meaningful result set. It is performed whenever you need to fetch records from two or more tables. They are used with SELECT statement and join conditions.
The following are the most commonly used joins in SQL:
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN

Sql
asked Apr 14, 2023 at 21:45
Sign in to add a comment

0 Answers

0
📝 No answers yet!

Be the first to answer this interview question.

Your Answer

Sign in to post your answer and help the community.