Post reply

How well do you know MAX?

  • August 4, 2011 at 10:38 pm

    #242568

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

  • August 5, 2011 at 1:10 am

    #1364113

    Good question. Thanks

    Thanks

  • August 5, 2011 at 1:24 am

    #1364120

    Nice question, thank you.

    Regards,

    Iulian

  • August 5, 2011 at 1:58 am

    This was removed by the editor as SPAM

  • August 5, 2011 at 2:00 am

    #1364134

    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

  • August 5, 2011 at 2:22 am

    #1364142

    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
    ----------------------------------------

  • August 5, 2011 at 2:42 am

    #1364149

    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:

  • August 5, 2011 at 2:43 am

    #1364150

    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

  • August 5, 2011 at 2:45 am

    #1364151

    Nice logic puzzle - good question.

    Tom

  • August 5, 2011 at 2:52 am

    #1364154

    Good q, thanks

    M&M

  • August 5, 2011 at 3:24 am

    #1364178

    A Good twisting question...

  • August 5, 2011 at 3:26 am

    #1364180

    Caught me out therefore an annoying question 😛

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

  • August 5, 2011 at 5:18 am

    #1364235

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

  • August 5, 2011 at 6:10 am

    #1364266

    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]

  • August 5, 2011 at 6:17 am

    #1364275

    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 59 total)

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