Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » How well do you know MAX?
Add to briefcase
60 posts, Page 1 of 6
12345»»»

How well do you know MAX? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
VM-723206
Posted Thursday, August 04, 2011 10:38 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263
Comments posted to this topic are about the item How well do you know MAX?
Post #1154736
Hardy21
Posted Friday, August 05, 2011 1:10 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158
Good question. Thanks

Thanks
Post #1154782
Iulian -207023
Posted Friday, August 05, 2011 1:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, March 16, 2013 9:53 AM
Points: 847, Visits: 768
Nice question, thank you.

Regards,
Iulian
Post #1154790
Stewart "Arturius" Campbell
Posted Friday, August 05, 2011 1:58 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311
Good twister for a Friday morning.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1154804
michael.kaufmann
Posted Friday, August 05, 2011 2:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263, Visits: 1,079
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
Post #1154805
BenWard
Posted Friday, August 05, 2011 2:22 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:23 AM
Points: 324, Visits: 531
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
----------------------------------------
Post #1154813
Michael Riemer
Posted Friday, August 05, 2011 2:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 AM
Points: 1,237, Visits: 346
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!
Post #1154822
Koen Verbeeck
Posted Friday, August 05, 2011 2:43 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467
Great question to check if I'm still awake at Friday


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1154823
L' Eomot Inversé
Posted Friday, August 05, 2011 2:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 7,087, Visits: 7,141
Nice logic puzzle - good question.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1154824
mohammed moinudheen
Posted Friday, August 05, 2011 2:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
Good q, thanks

Mohammed Moinudheen
Post #1154827
« Prev Topic | Next Topic »

Add to briefcase
60 posts, Page 1 of 6
12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.