There're many ways to get such result. Pick one that is most efficient for your data

* 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)

>I'm having a group by brain-fart. Somebody please point me in the right direction...
>
>I have the following data:
>

>ID|FK|Status|StartDate
>1|1|Started|1/1/2008
>2|1|Finished|1/2/2008
>3|2|Started|3/2/2008
>4|3|Started|5/1/2008
>5|3|Finished|5/4/2008
>

>
>This is a transactional flow of items through statuses. I would like to see what status each item is currently set to, which should be the greatest StartDate. In my example, I want to see:
>

>FK|Status
>1|Finished
>2|Started
>3|Finished
>

>
>Thanks in advance!