SQL 考試，大家踴躍參加

2010-04-13 17:25:19

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

balancedview 發表評論於 2010-04-13 18:36:21

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

登錄後才可評論.

澳-賊

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?