题解 | 牛客每个人最近的登录日期(二)

WITH t1 as(
SELECT U.name as u_n, C.name as c_n, l.date as date,
rank()over(partition by U.name Order by l.date desc) as rnk
FROM login l 
LEFT JOIN user U on l.user_id=U.id 
LEFT JOIN client C on l.client_id = C.id
ORDER BY U.name)

SELECT u_n, c_n, date
FROM t1
WHERE rnk = 1;