Most asked top Interview Questions and Answers | Online Test | Mock Test
Prepare Interview
Ask Question

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Question: Explain INNER JOIN and LEFT JOIN.
Answer: INNER JOIN returns rows when there is a match in both tables. LEFT JOIN returns all rows from the left table and matching rows from the right table.

Example:

SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Is it helpful? Yes No

Most helpful rated by users:

©2025 WithoutBook