How well do you know MAX?

  • VM-723206

    SSCrazy

    Points: 2964

    Comments posted to this topic are about the item How well do you know MAX?

  • Hardy21

    SSCrazy Eights

    Points: 9708

    Good question. Thanks

    Thanks

  • Iulian -207023

    SSCertifiable

    Points: 7509

    Nice question, thank you.

    Regards,

    Iulian

  • This was removed by the editor as SPAM

  • michael.kaufmann

    SSCrazy

    Points: 2816

    Thanks for the question.

    However, I do not quite agree with your answer that the query you provided is 'a bit of a trick question'; I'd rather consider it testing the ability to logically analyze and disect a given query. 😉

    Cool though, that you provided the less complex version to achieve the same result.

    Thanks again, nice question,

    Michael

  • BenWard

    SSCertifiable

    Points: 5903

    sneaky! very nearly got that one wrong.

    I think the use of 'not in' threw me off there as opposed to <>

    'not in' implies that multiple results are going to be excluded.

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • Michael Riemer

    SSCertifiable

    Points: 5099

    Great question and glad it was a bit of a trick, and not that we were looking for something funny in the behavior of MAX! :w00t:

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great question to check if I'm still awake at Friday 😀

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

  • TomThomson

    SSC Guru

    Points: 104773

    Nice logic puzzle - good question.

    Tom

  • M&M

    SSC-Insane

    Points: 21699

    Good q, thanks

    M&M

  • Latheesh NK

    SSCertifiable

    Points: 6559

    A Good twisting question...

  • Shark Energy

    SSCrazy Eights

    Points: 8389

    Caught me out therefore an annoying question 😛

    (obviously wouldn't have caught out anyone that ran it as usual...)

  • Richard Warr

    SSCertifiable

    Points: 6957

    Great question which illustrates why this type of technique should never be used in the real world!

    _____________________________________________________________________
    MCSA SQL Server 2012

  • DugyC

    Hall of Fame

    Points: 3804

    Great question, reminds me of the old logical puzzle exams in interviews.

    Cheers 😀

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Kiara

    SSCarpal Tunnel

    Points: 4185

    Nice question! I'm really, really glad I stopped, drank more coffee, and thought it through before answering though!

    -Ki

Viewing 15 posts - 1 through 15 (of 60 total)

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