Home Forums SQL Server 2008 T-SQL (SS2K8) Finding min and max date within a sub-group RE: Finding min and max date within a sub-group

  • November 5, 2012 at 4:59 pm

    #1556249

    Try this

    SELECT

    EMPLOYEE,

    MIN(EFECT_DATE) AS EFECT_DATE,

    MAX(END_DATE) AS END_DATE,

    JOB_CODE

    FROM TABLE

    GROUP BY EMPLOYEE,JOB_CODE

    HAVING JOB_CODE ='T009'