Ubuntu 安装 MySQL 8.0+

链接

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDEsbuUARz+IDZsW+OcYwJxqbcduj1+oRO/a+OiTamvAGAsVNNs8r37smMx3WssBleKcxK7XFo7O1Ent9VB6SN5V5jGUF0RBOWaVyGSR8gStnCdb4fBX21Pge59HciPwO+0jyDT7thGtDoFMWD8UPPcPVKFo+MiP21tS3NrUB1dDDMdx37QnB/0x1bWxnC7oHkPPOpC4XfaPKP3qCpOY/M2eHnOE4HcDwma0EFQwmDMGZOPsY9Fc4NqE0Y/rJ4pCstTg5CxoVP7E2g047byru76rp359ZY7sRTbvFU9eWtK2Q/btlyDocGd6vUgaka5xe6acf3XYaBqEN99fBgkJ1xv lg@lg-MRC-WX0

with eco_data as (select *, row_number() over (partition by player_id, currency_type order by timestamp  desc) as rank from 

(SELECT *  FROM `heidao-market.mafia1_ods.game_log_economy_data` WHERE timestamp> "2020-08-19 05:08:25 UTC" and timestamp< "2020-08-19 09:08:25 UTC"))



select currency_change ,currency_type, currency_value	,player_id,timestamp  from eco_data where rank=1