select b.blyjzj||'''' from (
select row_number() over(partition by sqid order by blsj nulls last) as nm,t.*
from xzxk_gzlkz_blyjb t
where t.hjdyid = 'jfqr'
and blyj = '本环节超过5个工作日,系统自动暂停' ) b where b.nm<>1;
转载于:https://blog.51cto.com/ty2538402559/1966934