目前,我的第一笔交易有以下内容:
select distinct on(T.player_id) T.player_id,(t.amount/100.0) as
amount,t.created,B.inserted,t.transaction_type_id
from wallet.transaction T
left join users.logindata B on B.playerid = t.player_id
where T.transaction_type_id = 1 and T.transaction_status_id = 6
group by T,player_id,t.amount,b.inserted,t.transaction_type_id
order by t.player_id,t.created
感谢您的帮助