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

  • August 5, 2011 at 6:21 am

    #1364279

    Glad I had finished my first cup of morning coffee to wake up that part of my mind that thinks logically.

    Thanks, a nice way to end the week, now hoping the remainder of my day is as good.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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