SELECT C.*, rownum,(SELECT count(*) 
  FROM (SELECT zlxmid,brid00,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,zwmc00,  ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, od0000,jgdw00,jgzcbz,yqdh00,sector,cupnum,photo1,photo2,  photo3,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,CUTOFF,SCO000  FROM VW_JY_JYJG00_temp WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * 
  FROM (SELECT zlxmid,brid00,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,zwmc00,  ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, od0000,jgdw00,jgzcbz,yqdh00,sector,cupnum,photo1,photo2,  photo3,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,CUTOFF,SCO000  FROM VW_JY_JYJG00_temp WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S')  
  ORDER BY DYSX00) C