Skip to content

Latest commit

 

History

History
20 lines (11 loc) · 409 Bytes

File metadata and controls

20 lines (11 loc) · 409 Bytes

中文文档

Description

None

Solutions

SQL

select player_id, device_id from Activity where (player_id, event_date) in ((select player_id, min(event_date) from Activity group by player_id))