SELECT * FROM ( SELECT PI.INDEXCODE FROM PLA_WARNING_CONFIG PWC LEFT JOIN PLA_INDEXCONTENT PI ON PWC.PCONID = PI.PCONID WHERE PI.Planid = '0E4K0NVI1P01001B' AND INDEXCODE < '06'
) WHERE ROWNUM < 2
SELECT * FROM (SELECT PI.INDEXCODE FROM PLA_WARNING_CONFIG PWC LEFT JOIN PLA_INDEXCONTENT PI ON PWC.PCONID = PI.PCONID WHERE PI.Planid = '0E4K0NVI1P01001B' AND INDEXCODE < '06') WHERE ROWNUM