select *
  from (select temptb1.*, rownum rn
          from (select ZYID00,
                       BQ_BRTZXX.JLRQ00 JLRQ00,
                       (BQ_BRTZXX.JLRQ00 || ' ' || BQ_BRTZXX.JLSJ00) JLRQSJ,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3000',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm0,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3001',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm1,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3002',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm2,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3003',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm3,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3004',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm4,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3005',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm5,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3006',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm6,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3007',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm7,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3008',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm8,
                       to_char(max(DECODE(bq_brtzxx.TZLBID,
                                          '3009',
                                          TZNR00 || '/' || ZWXM00,
                                          null))) clm9,
                       'black' Color,
                       BQ_BRTZXX.LRR000
                  from BQ_BRTZXX
                  left join BQ_TZLB00 on BQ_TZLB00.TZLBID = BQ_BRTZXX.TZLBID
                  left join BM_YGBM00 on BM_YGBM00.YGBH00 = BQ_BRTZXX.LRR000
                 where ZYID00 = 51438556
                   and HLDLB0 = '3'
                 group by JLRQ00, JLSJ00, ZYID00, LRR000, LRRQ00, LRSJ00
                 Order by JLRQSJ) temptb1) temptb2
 where rn > 0
   and rn <= 100;