17,090
社区成员
发帖
与我相关
我的任务
分享
select date from user group by date having max(date)=(select max(date) from user)
select a.* from user a where not exists (select 1 from user b where a.date < b.date)
select * from (select r.*,rownum rn from user r order by r.date desc )where rn =1