-- One select * from (select employeeid, effectivedate, designationid, max(effectivedate) over (partition by employeeid) meffectivedate from designationtransfers ) where effectivedate = meffectivedate -- Two select employeeid, effectivedate, designationid from designationtransfers t where effectivedate = (select max(effectivedate) from designationtransfers t1 where t.employeeid = t1.employeeid)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)