select PK, FK, Date from (select Date, PK, FK, row_number() OVER (partition by FK order by Date DESC) as rn) MaxDates where rn = 1>I have two tables, one with a date, PK and a FK to the second table. I need to select the latest date and the two keys for every group of FK's. If my data is this:
>Date PK FK >1/1/2001 1 1 >1/5/2002 2 1 >2/2/2001 3 1 >6/6/2005 4 2 >1/1/2005 5 2 >>Then I'd like my output to look like this:
>Date PK FK >1/5/2002 2 1 >6/6/2005 4 2 >>I'm having trouble coming up with a query to do this. Any ideas?