34,571
社区成员
发帖
与我相关
我的任务
分享
select b.userid,a.lemmaid,a.lemmaoil,a.shijian,b.userhead
from b left join a
on a.userid=b.userid and not exists(select 1 from a t where a.userid=t.userid and t.shijian>a.shijian)
where a.lemmaid=1 order by lemmaOil,shijian desc
userid lemmaid lemmaoil shijian userhead
-------------------------------------------------- -------------------- ----------- ------------------------------------------------------ --------------------------------------------------
vv 1 1 2008-04-09 00:00:00.000 c.gif
bb 1 2 2008-06-09 00:00:00.000 b.gif
aa 1 2 2008-02-09 00:00:00.000 a.gif
(所影响的行数为 3 行)
select b.userid,a.lemmaid,a.lemmaoil,a.shijian,b.userhead
from b left join a
on a.userid=b.userid and not exists(select 1 from a t where a.userid=t.userid and t.shijian>a.shijian)
where a.lemmaid=1 order by lemmaOil desc
userid lemmaid lemmaoil shijian userhead
-------------------------------------------------- -------------------- ----------- ------------------------------------------------------ --------------------------------------------------
aa 1 2 2008-02-09 00:00:00.000 a.gif
bb 1 2 2008-06-09 00:00:00.000 b.gif
vv 1 1 2008-04-09 00:00:00.000 c.gif
(所影响的行数为 3 行)
select b.userid,a.lemmaid,a.lemmaoil,a.shijian,b.userhead
from b left join a
on a.userid=b.userid and not exists(select 1 from a t where a.userid=t.userid and t.shijian>a.shijian)
where a.lemmaid=1 order by lemmaOil desc
select t.*,b.userHead from
select * from ta a where not exists(select 1 from ta where UserId = a.UserId and lemmaid<a.lemmaid and lemmaOil>a.lemmaOil ) t inner join tb b on a.UserId =b.UserId
select b.userid,a.lemmaid,a.lemmaoil,a.date,b.userhead
from b left join a
on a.userid=b.userid and not exists(select 1 from a t where a.userid=t.userid and t.date>a.date)
where a.lemmaid=1