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
SQL - outer join - ACE workbook
atulcse
asked
in
Databases
Oct 31, 2021
200
views
1
vote
1
vote
An outer join can be done between:
a. only two tables
b. only three tables
c. any number of tables
sql
databases
atulcse
asked
in
Databases
Oct 31, 2021
by
atulcse
200
views
answer
comment
Follow
share this
share
3 Comments
by
Chandrabhan Vishwa 1
commented
Oct 31, 2021
edited
Nov 1, 2021
by
Chandrabhan Vishwa 1
reply
Follow
share this
i think any number of table its operation sequence like as natural join
0
0
by
Awe111
commented
Nov 1, 2021
reply
Follow
share this
@atulcse
c. any number of tables ..
1.
https://gateoverflow.in/192299/Full-outer-join
2.
https://gateoverflow.in/228115/Ugc-net-july-2018-61
1
1
by
Manish pandey 9792
commented
Nov 1, 2021
reply
Follow
share this
with anynumber of table
because of it need minimum two table to perform outer join or inner join.
1
1
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
0
Answers
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
1
answer
1
Priyansh Singh
asked
in
Databases
Mar 29, 2019
530
views
Ace Test Series: Databases-Sql Query
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their ... pairwise comparison. $3.$It executes but does not give the correct result. $4.$It executes and gives the correct result.
Priyansh Singh
asked
in
Databases
Mar 29, 2019
by
Priyansh Singh
530
views
databases
ace-test-series
sql
1
vote
1
vote
1
answer
2
Na462
asked
in
Databases
Jan 19, 2019
707
views
Ace Test Series 2019: DBMS - SQL Output
Na462
asked
in
Databases
Jan 19, 2019
by
Na462
707
views
databases
sql
ace-test-series
1
vote
1
vote
1
answer
3
Shubhanshu
asked
in
Databases
Dec 24, 2018
886
views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
Shubhanshu
asked
in
Databases
Dec 24, 2018
by
Shubhanshu
886
views
sql
databases
query
ace-test-series
0
votes
0
votes
1
answer
4
Na462
asked
in
Databases
Jun 29, 2018
558
views
Ace Test Series: DBMS - SQL Query Output
Na462
asked
in
Databases
Jun 29, 2018
by
Na462
558
views
ace-test-series
databases
sql
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
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
From Rank 4200 to 64: My Journey to Success in GATE CSE Exam
What are the key things to focus on during the final 10-15 days before the GATE exam to improve performance?
All India GO Classes Mock test
NTA UGC NET JRF December 2022 Apply Online Form 2023
Life happens, just chill and do hardwork
Subjects
All categories
General Aptitude
(2.5k)
Engineering Mathematics
(9.3k)
Digital Logic
(3.3k)
Programming and DS
(5.8k)
Algorithms
(4.6k)
Theory of Computation
(6.7k)
Compiler Design
(2.3k)
Operating System
(5.0k)
Databases
(4.6k)
CO and Architecture
(3.8k)
Computer Networks
(4.6k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(649)
Exam Queries
(842)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(853)
Recent Blog Comments
AIMT is live now:...
It is at 9:30. Test Link will be available at...
@Deepak Poonia @Sachin Mittal 1 sir...
@mahendrapatel
Initially go classes planned on saturdays but...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy