SQL 考试，大家踊跃参加

a table
3 columns
acccountID, recordDate, price
how to get the latest price（max recordDate） for each account ID?

[balancedview]

select top 1 acccountID, recordDate, price from table order by recordDate desc;