Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Outer join Query
Anilava Kundu
asked
in
Databases
Oct 31, 2018
399
views
0
votes
0
votes
How is the maximum number of tuples for left outer join m*n. Can anyone please provide an example?
Anilava Kundu
asked
in
Databases
Oct 31, 2018
by
Anilava Kundu
399
views
answer
comment
Follow
share this
share
5 Comments
by
Magma
commented
Oct 31, 2018
reply
Follow
share this
All the tuples which are present in left side of table are present in the output
therefore m * n
0
0
by
Anilava Kundu
commented
Oct 31, 2018
reply
Follow
share this
How m*n ? If left side table contains m tuples and right contains n then if only left side tuples come there should be m tuples. Can you please give an example I can't seem to wrap my head around it.
0
0
by
Magma
commented
Oct 31, 2018
reply
Follow
share this
check it !
2
2
by
Tejasvi96
commented
Oct 31, 2018
reply
Follow
share this
in left outer join we basically have A xA \cap B) \cup A. IF there is nothing returned by the intersection then the output will produce m records. If for every record in A we have a record in B then number of tuples will be max(m,n).$
0
0
by
Anilava Kundu
commented
Oct 31, 2018
reply
Follow
share this
Thank you so much for the example! I have been at it for hours!
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
All the tuples which are there on the left-hand side will be present in the output as well.
Hence, the solution will be m*n, very simple, though Magma explained it very clearly with the sample diagram.
`JEET
answered
Oct 31, 2018
by
`JEET
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
1
answer
1
atulcse
asked
in
Databases
Oct 31, 2021
435
views
SQL - outer join - ACE workbook
An outer join can be done between: a. only two tables b. only three tables c. any number of tables
atulcse
asked
in
Databases
Oct 31, 2021
by
atulcse
435
views
sql
databases
0
votes
0
votes
1
answer
2
Chirag arora
asked
in
Databases
Jun 29, 2018
423
views
Full outer join
Can any one explain this question
Chirag arora
asked
in
Databases
Jun 29, 2018
by
Chirag arora
423
views
0
votes
0
votes
1
answer
3
Subhajit Majumder 1
asked
in
Databases
Jun 27, 2018
460
views
Left Outer Join
Is LEFT OUTER JOIN commutative in nature?
Subhajit Majumder 1
asked
in
Databases
Jun 27, 2018
by
Subhajit Majumder 1
460
views
databases
6
votes
6
votes
2
answers
4
hacker16
asked
in
Databases
Jan 9, 2018
3,754
views
Full Outer Join
Why is the minimum number of tuples in full outer join equal to max (m,n) ?
hacker16
asked
in
Databases
Jan 9, 2018
by
hacker16
3.8k
views
databases
full-outer-join
relational-algebra
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy