27,580
社区成员
发帖
与我相关
我的任务
分享
select * from A left join B weher A.id=B.cid and B.adddate=(select adddate from B ordey by adddate)
这样不知道可以不。
select * from
select *,row_number() over(partition by id order by adddate) as rw
from a left join b on id=cid
)a where rw = 1
select top 1 * from a left join b on id=cid order by adddate