SQL JOINS

Question

Post reply

SQL JOINS

Viewing 10 posts - 16 through 24 (of 24 total)

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

Ed B Hall of Fame Points: 3618 More actions · Answer 1

Ed B

Hall of Fame

Points: 3618

April 15, 2013 at 10:11 am

#1606532

Where was the trick?

Ken SSCoach Points: 17191 More actions · Answer 2

Thanks for an easy one to start the week off with.

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 3

Easy one

I have given answer by eliminating the wrong ones. First two query returns 4 and only one answer contains 4,4 so no need to check others..

Thanks

Jan Van der Eecken SSCrazy Eights Points: 9029 More actions · Answer 4

Agree with Hugo (again), but then again I should have read the question properly and wouldn't have a red cross next to my answer. 😛

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

demonfox SSCertifiable Points: 6289 More actions · Answer 5

I don't see any trick ; easy one ...

adding join on duplicate values, make it like a cross product, get plenty of duplicate rows , add filter and add distinct 😛 sound like fun , proper design could overcome that though..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Dana Medley SSCertifiable Points: 6764 More actions · Answer 6

Danny Ocean (4/14/2013)
Good start of week.
Thanks for question.
🙂

+1

Everything is awesome!

Miles Neale SSChampion Points: 13147 More actions · Answer 7

Miles Neale

SSChampion

Points: 13147

April 16, 2013 at 12:33 pm

#1606987

Nice. +1

Not all gray hairs are Dinosaurs!

David Conn SSCertifiable Points: 5980 More actions · Answer 8

The Question was easy enough. A few people are asking whether the QOTD should be Test / Teach. To me they're the same thing. If I get a Question wrong then I've learned something. If I get it right then I've passed the Test.

The Trick questions that I don't like are those where you have to know certain default values that aren't obvious.

David

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 9

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sqlnaive SSCoach Points: 17437 More actions · Answer 10

I found the question easy. but definitely it was very good question and hopefully brought good understanding of joins for few. 🙂