Post reply

selecting umatched rows only

  • May 3, 2007 at 9:11 am

    #117173

    hi guys, i have two queries where i'm sekecting Max and Min Dates from a table. What i want to do next, is to max date in the second query without the resultset display similar dates in the resultset of the other query.

    example: i'm getting the following resultset

    Min Date      Max date

    02/jan/2003   03/jan/2003

    02/feb/2003   02/feb/2003

     

    Desired:

    Min Date          Max Date

    02/Jan/2003     03/jan/2003

    02/feb/2003          Null

     

    thx pple

  • May 3, 2007 at 9:34 am

    #704121

    try this in the query:

    nullif(max(datecol),min(datecol))

  • May 3, 2007 at 1:19 pm

    #704191

    Can you post the 2 queries you are using?

  • May 3, 2007 at 1:37 pm

    #704198

    ooh srry man, i got it solved,  Lynn's method works fine

Viewing 4 posts - 1 through 3 (of 3 total)

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