How well do you know MAX?

  • VM-723206


    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


  • Iulian -207023


    Points: 7509

    Nice question, thank you.



  • This was removed by the editor as SPAM

  • michael.kaufmann


    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,


  • BenWard


    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.


    ^ Thats me!

    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010

  • Michael Riemer


    Points: 5136

    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
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • TomThomson

    SSC Guru

    Points: 104773

    Nice logic puzzle - good question.


  • M&M


    Points: 21699

    Good q, thanks


  • Latheesh NK


    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


    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!


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

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