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;
登录后才可评论.