题解 | #获取所有非manager员工当前的薪水情况#
牛客每个人最近的登录日期(三)
http://www.nowcoder.com/practice/16d41af206cd4066a06a3a0aa585ad3d
虽然sql不雅观，但是就要和大伙不一样，卷死大伙
select round((select count(1)
from login l1
join (
select user_id, min(date) mdate
from login
group by user_id
) t on l1.user_id = t.user_id and l1.date = date_add(t.mdate, interval 1 day)) /
(select count(distinct user_id) from login),3) as p;
查看8道真题和解析
领导找我续签到明年3、4月我要继续吗