22,209
社区成员
发帖
与我相关
我的任务
分享
select *
from ta t
where not exists(select 1 from ta where 客户ID=t.客户ID and 服务time > t.服务time)
select *
from ta t
where not exists(select 1 from ta where 客户ID=t.客户ID and 服务time < t.服务time)
select *
from ta t
where not exists(select 1 from ta where 用户ID=t.用户ID and logtime > t.logtime)
select *
from ta t
where not exists(select 1 from ta where 用户ID=t.用户ID and logtime < t.logtime)