select *
from (select t.*, row_number() over (order by worklist_id desc) as rnum
from table_name t where t.wf_serial_no='1342121')
where rnum = 1;
Oracle取某字段最大的整行记录内容
最新推荐文章于 2024-06-11 14:27:48 发布
select *
from (select t.*, row_number() over (order by worklist_id desc) as rnum
from table_name t where t.wf_serial_no='1342121')
where rnum = 1;