一,(字段1,字段2) in (select ...)
1)案例链接:
力扣https://leetcode.cn/problems/game-play-analysis-ii/
2)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)
3)注意点:
踩坑:(字段1,字段2) in (select ...),字段1和字段2要在一起,在外面加上括号()。