MS SQL Developer Interview Questions and Answers

Types of joins in SQL include inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all rows from the left table and the matching rows from the right table.

• Right join returns all rows from the right table and the matching rows from the left table.

• Full outer join returns all rows from both tables, including unmatched rows.

• Examples: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;

• SELEC...read more