Nested Subquery vs Correlated Subquery

Question

Nested Subquery vs Correlated Subquery

rinu.gour123

Valued Member

Points: 53
More actions
February 21, 2019 at 5:24 am

#409540

What is the difference between Nested Subquery and Correlated Subquery?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173094 More actions · Answer 1

rinu.gour123 - Thursday, February 21, 2019 5:24 AM
What is the difference between Nested Subquery and Correlated Subquery?

Google this term: correlated subquery sql server example

There are plenty of examples available, including a Microsoft Docs reference. If you have a question about one of the specific examples, feel free to post it here.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

drew.allen SSC Guru Points: 77005 More actions · Answer 2

One is a proper subset of the other. Also, sub-queries are necessarily nested, so nobody uses the term nested.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

saneepatel123 Grasshopper Points: 18 More actions · Answer 3

Subquery inside another Subquery is called as Nested Subquery. On the off chance that the yield of a subquery is relying upon segment estimations of the parent inquiry table then the question is called Correlated Subquery.

SELECT adminid(SELEC Firstname+' '+Lastname FROM Employee WHERE
empid=emp. adminid)AS EmpAdminId FROM Employee;

saravanatn SSCarpal Tunnel Points: 4533 More actions · Answer 4

rinu.gour123 - Thursday, February 21, 2019 5:24 AM
What is the difference between Nested Subquery and Correlated Subquery?

Hi Rinu,

Coming to the forum is good . But even in this google era where you can get instant answer asking this questions !!!!
Experts and MVP already knows the answer for it. First you should do hard work and put the effort then you can always find a way to do smarter.

Saravanan