Explain the difference between INNER JOIN and LEFT JOIN in SQL. - Study24x7
Social learning Network
Ashish Verma
19 Mar 2024 11:16 AM study24x7 study24x7

Explain the difference between INNER JOIN and LEFT JOIN in SQL.

A

They are synonymous and can be used interchangeably

B

INNER JOIN returns only matching rows, while LEFT JOIN returns all rows from the left table and matching rows from the right table 

C

 LEFT JOIN returns only matching rows, while INNER JOIN returns all rows from the left table and matching rows from the right table

D

 INNER JOIN is used for numeric data, while LEFT JOIN is used for text data

Mobile Technologies Computer Programming Web Development
Like Comment Share
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles