SQL 考试,大家踊跃参加

澳-贼 (2010-04-13 17:25:19) 评论 (5)

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