Comments posted to this topic are about the item How well do you know MAX?
Good question. Thanks
Nice question, thank you.
This was removed by the editor as SPAM
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,
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
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:
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
Nice logic puzzle - good question.
Good q, thanks
A Good twisting question...
Caught me out therefore an annoying question 😛
(obviously wouldn't have caught out anyone that ran it as usual...)
Great question which illustrates why this type of technique should never be used in the real world!
MCSA SQL Server 2012
Hall of Fame
Great question, reminds me of the old logical puzzle exams in interviews.
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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 59 total)