Subqueries II

Question

Subqueries II

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
December 6, 2024 at 12:00 am

#4475600

Comments posted to this topic are about the item Subqueries II

Viewing 8 posts - 1 through 7 (of 7 total)

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

Neil Burton SSC-Insane Points: 23009 More actions · Answer 1

Two of the options look identical. I'm not sure there's a right answer to this at the moment.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Rune Bivrin SSCrazy Eights Points: 8524 More actions · Answer 2

There are all sorts of wrong with that code, but only one that actually stops it from executing.

Just because you're right doesn't mean everybody else is wrong.

joshua.banks Grasshopper Points: 16 More actions · Answer 3

If you're just seeing if the customerid exists in the other table shouldn't this be an EXISTS clause? No need to return the results of the subquery just see if what you need is there or not and be on your way...

Rune Bivrin SSCrazy Eights Points: 8524 More actions · Answer 4

joshua.banks wrote:

If you're just seeing if the customerid exists in the other table shouldn't this be an EXISTS clause? No need to return the results of the subquery just see if what you need is there or not and be on your way...

True, but if you look closely at the subquery, it doesn't quite do that. Probably not intentionally, though...

Just because you're right doesn't mean everybody else is wrong.

webrunner SSC-Dedicated Points: 31882 More actions · Answer 5

Two answers are the same. I wanted to pick that you can't have ORDER BY in a subquery but that wasn't an option.

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

Apologies for the duplicate answer. That doesn't affect the question, but I'll award back points and change it to something else (wrong).

webrunner SSC-Dedicated Points: 31882 More actions · Answer 7

Thanks, Steve! Always appreciate your QOTD.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html