SELECT u.name, c.name, l.date FROM user u INNER JOIN login l ON u.id = l.user_id LEFT JOIN client c ON c.id = l.client_id WHERE l.date = (SELECT MAX(date) AS d FROM login l1 WHERE l.user_id = l1.user_id) GROUP BY l.user_id ORDER BY u.name 请问下我这样查行吗。因为我看前面好多题解1楼都是这样的关联子查询
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务