Post reply

HOW TO GET FIRST DATE

  • October 19, 2018 at 5:53 am

    #2010394

    sgmunson - Thursday, October 18, 2018 9:26 AM

    Tom Van Harpen - Tuesday, October 16, 2018 2:09 PM

    I would first tell her about SQL and show how an Over clause works. That's a sure bet.... 

    Good luck with that....   The number of gals interested in such topics is rather unfortunately low....

    To put my wife to sleep, all I have to do is say  'S'   'Q'   zzzzzzzzzzzzzzzzzzzzzzz. 
    I never make it to the 'L'

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • October 21, 2018 at 6:03 pm

    #2010528

    Tom Van Harpen - Tuesday, October 16, 2018 2:09 PM

    I would first tell her about SQL and show how an Over clause works. That's a sure bet.... 

    Here's an example
    SELECT
    ss.NAME
    ,ss.SPONSOR_NAME
    ,ss.DATE_OF_CALL
    FROM
    (SELECT
      *
     ,MIN(DATE_OF_CALL) OVER (PARTITION BY SPONSOR_NAME) AS MinDoc
     FROM
      Testing_Name) ss
    WHERE
    ss.DATE_OF_CALL = ss.MinDoc;

    Hai All,,
    Thank you for your help for this case,,I'd like to follow your suggestions..
    Thank you very much

Viewing 2 posts - 16 through 16 (of 16 total)

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