select * from (select myTable.*, row_number() over (partition by PartNo order by DatStMpi DESC) as rn from myTable where myCondition) myMaxDates where rn=1see http://forums.asp.net/t/1380333.aspx
>( SELECT webprddt6.drawmfai.partno, MAX(webprddt6.drawmfai.datstmpi) AS MaxDate FROM webprddt6.drawmfai Where toolinspr = 0 And conformir = 0 And DATE(datstmpin) is Not NULL GROUP BY webprddt6.drawmfai.partno) >>