34,590
社区成员
发帖
与我相关
我的任务
分享
select cuno,cano,cadt from tb t
where cadt=(select min(cadt) from tb where cuno=t.cuno )
--or
select * from tb t
where not exists(select 1 from tb where cuno=t.cuno and cadt<t.cadt )
--0r
select * from tb as t
where 创建日期=(select min(创建日期) from tb where 客户=t.客户 )
select * from T a where exists (select cuno ,min(cadt)
from T group by cuno where a.cuno =cuno)