mysql
select player_id,min(event_date) as first_login
from Activity
group by player_id
select player_id,event_date as first_login
from Activity
group by player_id
having event_date = min(event_date)
为什么下面这种方式是错的,
from Activity
group by player_id
select player_id,event_date as first_login
from Activity
group by player_id
having event_date = min(event_date)
为什么下面这种方式是错的,
全部评论
相关推荐
小小:推荐牛客大厂面试实时更新:https://m.nowcoder.com/mianshi/top 点赞 评论 收藏
分享
凸守早苗:耐面王
点赞 评论 收藏
分享