鹅鸭杀没鸡

分类

题解(11)

/ 注册

全部文章（共1篇）

涉及到max函数的链接表sql写法

select u.name, c.name, date from user u,client c,login l where l.user_id = u.id and l.client_id = c.id and (user_id, date) in (select user_id, max(da...

Mysql

2021-10-08

0 212