4 Replies Latest reply on Oct 23, 2013 7:49 AM by Chris Amburn

    Correlated Subquery

    Chris Amburn

      Hello,  I am trying to create a table that will pull current position and previous position into one row of data.  There are multiple effective dates to reference, and I only want the max one for the previous job.  Is there a way to do this in custom SQL?  I normally run this in SAS and use Having EFFDT = Max(EFFDT).  Thanks for your help.