Why use Full Join in SQL? - Study24x7
Social learning Network
study24x7

Default error msg

Login

New to Study24x7 ? Join Now
Already have an account? Login
googlePlay app_img
DatabaseManagementSystems
45 followers study24x7 18 Dec 2020 04:31 PM study24x7 study24x7

Why use Full Join in SQL?

A

Return rows when there is at least one match in both tables

B

Return all rows from the left table, even if there are no matches in the right table

C

Return all rows from the right table, even if there are no matches in the left table

D

Return rows when there is a match in one of the tables

Databases IIT-JEE MCA
Like Comment Share
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Popular Courses

Database Design All Levels English By Dr S Srinath
Advanced Foundation Engineering All Levels English By Kousik Deb
NOC:Software Engineering All Levels English By Prof. Rajib Mall
Free SEO training: SEO for beginner... Beginners Level English By Digital Marketing - Learn SEO, PPC,...
Mechanical Engineering Mock Test Se... Beginners Level English By Study24x7 99 399 75% off
English Beginners Level English By Study Anywhere
H.C. Verma Solution All Levels English By HC Verma FanClub
SSC CGL, CPO, CHSL, GD Comprehensiv... All Levels English By Topline Coaching 3,999 5,499 27% off
English Special Course for SSC CGL,... All Levels English By Topline Coaching 999 1,499 33% off
Online Free SSC Mock Tests All Levels English By Topline Coaching
Featured Courses
Popular Pages

Featured Courses

Database Design All Levels English By Dr S Srinath
FREE
5.0
English Special Course for SSC CGL, CPO, GD All Levels English By Topline Coaching 999 5.0
Online Free SSC Mock Tests All Levels English By Topline Coaching
FREE
4.5
Free SEO training: SEO for beginners Beginners Level English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
5.0
Math Special Course for SSC CGL, CPO, GD All Levels हिन्दी By Topline Coaching 999 5.0
Free SEO Link Building Guide 2019 All Levels English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
4.5
CAPF(AC) | Test Series All Levels English By Ajabs Academy Pvt Ltd
FREE
5.0
NDA Exam Online Course 2021-2022 Beginners Level English By Sigma Classes 15,000 5.0
A Premium Course For English Special (All One Day ... All Levels English By Vivishka Learning and Test Series 999 5.0
BESTSELLER
SSC CGL, CPO, CHSL, GD Comprehensive Course All Levels English By Topline Coaching 3,999 5.0

Popular Pages

SAT (Scholastic Assessment Test)

18 followers

Study24x7

1218 followers

Henry Harvin

58 followers

SSC Preparation Strategies & Study Mater...

1541 followers

CBSE Study Materials

83 followers

Banking/IRDA

265 followers

Digital Marketing - Learn SEO, PPC, SMO,...

756 followers

DEFENCE EXAM PREPARATION

22 followers

Defence

106 followers

Vivishka Learning and Test Series

343 followers

Get the App

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

study24x7
study24x7
Most Related Articles