select a.player_id,a.device_id
from Activity a,(select player_id,min(event_date)as ev from Activity group by player_id) z
where a.player_id=z.player_id and a.event_date=z.ev
1、题目描述来源:力扣(LeetCode)2、解题思路1# 使用子查询,查出每个player_id的首次login日期,作为表z2# 与Activity2表联查3、提交记录select a.player_id,a.device_idfrom Activity a,(select player_id,min(event_date) as ev from Activity group ...