use inner join and sub query

來源: smartpanda 於 2010-04-13 20:11:50 [] [舊帖] [給我悄悄話] 閱讀數 : (190 bytes)

select a.* from table a
inner join
(select accountid, max(recordDate) as latestdate from table
group by accountid) b on a.accountid = b.accountid and
a.recorddate = b.latestdate

請您先登陸，再發跟帖！