>>* 1 >>SELECT * FROM mytable mt1 >> WHERE StartDate = (SELECT MAX(StartDate) FROM mytable mt2 where mt2.fk = mt1.fk) >> >>* 2 >>SELECT * FROM mytable mt1 >> JOIN (SELECT fk, MAX(StartDate) AS MaxStartDate FROM mytable GROUP BY fk) dt1 >> ON dt1.fk = mt1.fk AND dt1.MaxStartDate = mt1.StartDate >> >>* 3 >>SELECT * FROM mytable mt1 >> WHERE NOT EXISTS (SELECT 1 FROM mytable mt2 where mt2.fk = mt1.fk AND mt2.StartDate > mt1.StartDate) >>>>