1.21 --DESC : 扎回坯再次编制的时候会找到两条记录 --content :增加 AND STATUS_CD IN ('A','B') SELECT A.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_ST ,B.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_EN ,C.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_TG FROM (SELECT ROLL_SLAB_SEQ FROM TBF02_SPEC_MILL WHERE SLAB_NO = ? AND STATUS_CD IN ('A','B')) A ,(SELECT ROLL_SLAB_SEQ FROM TBF02_SPEC_MILL WHERE SLAB_NO = ? AND STATUS_CD IN ('A','B')) B ,(SELECT ROLL_SLAB_SEQ FROM TBF02_SPEC_MILL WHERE SLAB_NO = ? AND STATUS_CD IN ('A','B')) C ]]> ? AND A.ROLL_SLAB_SEQ <= ? AND A.ROLL_MANA_NO = ? ]]>