Given a table and data like
Id Year Code ColB ColC
1 2013 A Foo Bar
2 2014 A Baz Qux
3 2014 B Jax Fizz
4 2013 C Buub Baq
I wish to select the "newest" row for each code, e.g.:
Id Year Code ColB ColC
2 2014 A Baz Qux
3 2014 B Jax Fizz
4 2013 C Buub Baq
I see this can be done directly in SQL
select a,b
from (
select a,b,row_number() over(partition by a order by b desc) as roworder
from myTable
) temp
where roworder = 1
https://stackoverflow.com/a/7344770/141172
Can this be expressed in Linq to Entities?