题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
牛客每个人最近的登录日期(二)
http://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select x.u_n, x.c_n, x.date from (SELECT u.name as u_n, c.name as c_n, l.date, row_number()over(PARTITION by u.name order by l.date desc)mm FROM login l LEFT JOIN user u on u.id =l.user_id left JOIN client c on c.id =l.client_id)x WHERE x.mm =1
查看17道真题和解析