I have a table that contains a Year, and AnnualPay, and a person's name.
How do I find the latest annual pay.
Select AnnualPay from MyTable where name='MyName' and
Year = max(Year) where name='MyName'
(That's probably not right be should show what I"m looking for.)