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;
原文：http://ty2538402559.blog.51cto.com/9486194/1966934