I have a table in visual studio that lists nonprofit grant recipients for a number of years.
How can I automatically pull the largest grant for each year. For example, my results would show Nonprofit2 with the amount for 2006 and Nonprofit5 with the amount for 2007.
I assume it's some kind of command with MAX, but I'm not sure how to write it.
Recipient Amount Year
Nonprofit1 $4,000 2006
Nonprofit2 $8,000 2006
Nonprofit3 $2,000 2006
Nonprofit4 $1,000 2007
Nonprofit5 $2,000 2007