Leetcode 511. 游戏玩法分析 I SQL 解题答案

贝极星Kira

已于 2024-07-08 17:05:16 修改

阅读量93

点赞数 1

文章标签： leetcode 游戏 sql

于 2024-07-08 17:03:34 首次发布

本文链接：https://blog.csdn.net/qq_48596586/article/details/140273378

版权

解法1：

select
    distinct player_id, min(event_date) asfirst_login
from
    Activity
group by
    player_id

解法2：

select
    player_id, first_login
from
    (
        select
            player_id, event_date AS first_login, row_number() OVER(partition by player_id order by event_date) as rn
        from
            Activity
    ) as sq1
where rn = 1;

解法3：

select 
    player_id, first_login
from
    (
        select distinct
            player_id, first_value(event_date) OVER(partition by player_id order by event_date) as first_login
        from
            Activity
    ) as sq1;