澳——賊， 你轉不出來才說呢

來源: Fagger 於 2010-04-13 22:28:16 [] [博客] [舊帖] [給我悄悄話] 閱讀數 : (254 bytes)

select t.acccountID, a.mDate, t.price
from table t,
(select acccountID, max(recordDate) as mDate
from table
group by acccountID) as a
where t. acccountID=a. acccountID
and t. recordDate=a.mDate
group by t.acccountID, a.mDate, t.price

請您先登陸，再發跟帖！