订单号 会员ID 交易金额 交易时间
1 A 12.0 1440483785692
2 A 11.0 1410483785692
3 A 11.0 1420483785692
4 B 22.0 1440483785692
5 B 32.0 1430483785392
6 B 12.0 1420483785692
7 C 12.0 1440483785292
8 C 42.0 1440483785692
9 C 52.0 1420483785622
select tb.订单号,tb.会员ID.tb.交易金额,tb.交易时间
from tb
inner join
(
select 会员ID,max(交易时间) 交易时间
from tb
group by 会员ID
)t
on tb.会员ID = t.会员ID and tb.交易时间 = t.交易时间
order by tb.会员ID,tb.订单号
