Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *
- FROM
- (
- SELECT
- /*+ FIRST_ROWS(50) */
- SITE_CODE,
- ( SELECT UNIT || ' ' || NAME FROM SITE WHERE SITE_CODE_EXIST = SITE_CODE AND SITE_TYPE_ID = 5 ) SITE_NAME,
- LOCATION_CODE,
- LOCATION_NAME,
- POWER,
- SUSPECT_CATEGORY,
- JUMLAH,
- ROW_NUMBER () OVER ( ORDER BY POWER DESC, JUMLAH DESC, LAST_NOTES DESC NULLS LAST ) RN,
- MAX( ROWNUM ) OVER ( ORDER BY NULL ) CNT,
- LAST_NOTES
- FROM
- (
- SELECT
- SITE_CODE,
- A.LOCATION_CODE,
- LOCATION_NAME,
- POWER,
- SUSPECT_CATEGORY,
- COUNT( * ) JUMLAH,
- MAX(
- B.UPDATE_DATE
- ) LAST_NOTES
- FROM
- SUSPECT_LOADPROFILE A
- LEFT JOIN SUSPECT_NOTES B ON A.LOCATION_CODE = B.LOCATION_CODE
- WHERE
- SUSPECT_CATEGORY = '1'
- AND DATE_READ BETWEEN '20190601'
- AND '20190630'
- AND POWER BETWEEN 195000
- AND 198000
- GROUP BY
- SITE_CODE,
- A.LOCATION_CODE,
- LOCATION_NAME,
- POWER,
- SUSPECT_CATEGORY
- )
- WHERE
- (
- SITE_CODE IN (
- 'SUM',
- '11',
- '11BNA',
- '11110',
- '11111',
- '11112',
- '11113',
- '11114',
- '11115',
- '11LSA',
- '11330',
- '11331',
- '11332',
- '11333',
- '11334',
- '11335',
- '11LSM',
- '11220',
- '11221',
- '11222',
- '11223',
- '11224',
- '11225',
- '11226',
- '11227',
- '11228',
- '11229',
- '11230',
- '11MBO',
- '11440',
- '11441',
- '11442',
- '11443',
- '11444',
- '11SBS',
- '11550',
- '11551',
- '11552',
- '11553',
- '11554',
- '11555',
- '11556',
- '11SGL',
- '11660',
- '11661',
- '11662',
- '12',
- '12120',
- '12001',
- '12002',
- '12003',
- '12004',
- '12010',
- '12011',
- '12012',
- '12013',
- '12014',
- '12121',
- '12101',
- '12110',
- '12111',
- '12112',
- '12113',
- '12114',
- '12115',
- '12116',
- '12117',
- '12118',
- '12119',
- '12102',
- '12122',
- '12201',
- '12202',
- '12203',
- '12210',
- '12211',
- '12212',
- '12213',
- '12214',
- '12215',
- '12216',
- '12217',
- '12218',
- '12219',
- '12221',
- '12123',
- '12301',
- '12310',
- '12311',
- '12312',
- '12313',
- '12314',
- '12315',
- '12124',
- '12401',
- '12410',
- '12411',
- '12412',
- '12413',
- '12414',
- '12415',
- '12125',
- '12501',
- '12510',
- '12511',
- '12512',
- '12513',
- '12514',
- '12515',
- '12516',
- '12126',
- '12610',
- '12611',
- '12612',
- '12613',
- '12614',
- '12615',
- '12616',
- '12617',
- '12127',
- '12710',
- '12711',
- '12712',
- '12128',
- '12801',
- '12802',
- '12803',
- '12804',
- '12129',
- '12901',
- '12902',
- '12903',
- '12904',
- '12905',
- '12906',
- '13',
- '13100',
- '13101',
- '13102',
- '13103',
- '13104',
- '13105',
- '13106',
- '13107',
- '13108',
- '13109',
- '13110',
- '13111',
- '13112',
- '13200',
- '13221',
- '13222',
- '13223',
- '13224',
- '13225',
- '13226',
- '13227',
- '13300',
- '13331',
- '13332',
- '13333',
- '13334',
- '13335',
- '13336',
- '13337',
- '13338',
- '13339',
- '13400',
- '13451',
- '13452',
- '13453',
- '13454',
- '14',
- '14BKL',
- '14500',
- '14510',
- '14600',
- '14610',
- '14620',
- '14630',
- '14640',
- '14660',
- '14680',
- '14690',
- '14JMB',
- '14300',
- '14310',
- '14320',
- '14350',
- '14360',
- '14390',
- '14LHT',
- '14700',
- '14710',
- '14720',
- '14730',
- '14740',
- '14750',
- '14760',
- '14770',
- '14780',
- '14790',
- '14850',
- '14MBO',
- '14400',
- '14410',
- '14420',
- '14430',
- '14440',
- '14450',
- '14460',
- '14PLB',
- '14100',
- '14110',
- '14120',
- '14130',
- '14200',
- '14220',
- '14230',
- '14240',
- '14250',
- '14260',
- '14OGI',
- '14900',
- '14910',
- '14930',
- '14920',
- '16',
- '16BGK',
- '16100',
- '16110',
- '16120',
- '16130',
- '16140',
- '16TJP',
- '16300',
- '16310',
- '16320',
- '17',
- '17171',
- '17100',
- '17110',
- '17120',
- '17130',
- '17131',
- '17150',
- '17180',
- '17172',
- '17200',
- '17210',
- '17220',
- '17230',
- '17240',
- '17250',
- '17260',
- '17270',
- '17280',
- '17173',
- '17300',
- '17330',
- '17360',
- '17370',
- '17380',
- '17340',
- '18',
- '18DMI',
- '18210',
- '18220',
- '18230',
- '18240',
- '18250',
- '18260',
- '18270',
- '18PKU',
- '18110',
- '18111',
- '18120',
- '18130',
- '18140',
- '18150',
- '18160',
- '18170',
- '18180',
- '18190',
- '18112',
- '18113',
- '18114',
- '18RGT',
- '18410',
- '18420',
- '18430',
- '18440',
- '18450',
- '18TPI',
- '18301',
- '18302',
- '18303',
- '18304',
- '18305',
- '18306',
- '18307',
- '18308',
- '18309',
- '18310',
- 'JBB',
- '54',
- '54110',
- '54110',
- '54130',
- '54130',
- '54210',
- '54210',
- '54310',
- '54310',
- '54330',
- '54330',
- '54360',
- '54360',
- '54380',
- '54380',
- '54410',
- '54410',
- '54420',
- '54420',
- '54510',
- '54510',
- '54530',
- '54530',
- '54630',
- '54630',
- '54710',
- '54710',
- '54720',
- '54720',
- '54730',
- '54730',
- '54740',
- '54740',
- '54830',
- '54840',
- '56',
- '56100',
- '56110',
- '56130',
- '56120',
- '56140',
- '56150',
- '56200',
- '56210',
- '56220',
- '56230',
- '56240',
- '56610',
- '56610',
- '56620',
- '56620',
- '56640',
- '56640',
- '56660',
- '56660',
- '56820',
- '56820',
- 'JBT',
- '52',
- '52000',
- '52001',
- '52002',
- '52003',
- '52004',
- '52005',
- '52006',
- '52007',
- '52008',
- '52050',
- '52051',
- '52052',
- '52053',
- '52054',
- '52055',
- '52056',
- '52057',
- '52058',
- '52059',
- '52060',
- '52061',
- '52090',
- '52099',
- '52100',
- '52101',
- '52102',
- '52103',
- '52104',
- '52105',
- '52106',
- '52107',
- '52108',
- '52150',
- '52151',
- '52152',
- '52153',
- '52154',
- '52155',
- '52156',
- '52157',
- '52200',
- '52201',
- '52202',
- '52203',
- '52204',
- '52205',
- '52206',
- '52207',
- '52250',
- '52251',
- '52252',
- '52253',
- '52254',
- '52255',
- '52256',
- '52257',
- '52258',
- '52259',
- '52260',
- '52300',
- '52301',
- '52302',
- '52303',
- '52304',
- '52305',
- '52306',
- '52308',
- '52309',
- '52310',
- '52350',
- '52351',
- '52352',
- '52353',
- '52400',
- '52401',
- '52402',
- '52403',
- '52404',
- '52405',
- '52450',
- '52451',
- '52452',
- '52453',
- '52454',
- '52500',
- '52501',
- '52502',
- '52503',
- '52504',
- '52505',
- '52506',
- '52550',
- '52551',
- '52552',
- '52553',
- '52554',
- '52650',
- '52651',
- '52652',
- '52653',
- '52654',
- '52655',
- '53',
- '53BDG',
- '53551',
- '53555',
- '53559',
- '53563',
- '53567',
- '53571',
- '53575',
- '53577',
- '53BGR',
- '53811',
- '53821',
- '53825',
- '53831',
- '53841',
- '53851',
- '53853',
- '53BKS',
- '53711',
- '53721',
- '53731',
- '53732',
- '53741',
- '53742',
- '53751',
- '53761',
- '53762',
- '53771',
- '53CJR',
- '53661',
- '53671',
- '53681',
- '53691',
- '53695',
- '53CKR',
- '53CMI',
- '53581',
- '53585',
- '53589',
- '53592',
- '53595',
- '53598',
- '53599',
- '53CRB',
- '53311',
- '53321',
- '53331',
- '53341',
- '53351',
- '53361',
- '53371',
- '53381',
- '53DPK',
- '53871',
- '53872',
- '53873',
- '53874',
- '53875',
- '53GPI',
- '53861',
- '53865',
- '53867',
- '53GRT',
- '53271',
- '53276',
- '53277',
- '53286',
- '53293',
- '53KRW',
- '53461',
- '53468',
- '53475',
- '53476',
- '53482',
- '53MJA',
- '53531',
- '53532',
- '53533',
- '53534',
- '53535',
- '53536',
- '53PWK',
- '53411',
- '53421',
- '53425',
- '53431',
- '53444',
- '53SKI',
- '53611',
- '53621',
- '53631',
- '53641',
- '53651',
- '53659',
- '53SMD',
- '53511',
- '53517',
- '53521',
- '53527',
- '53TSK',
- '53211',
- '53221',
- '53231',
- '53241',
- '53251',
- '53261',
- '53265',
- '53CKG',
- '53701',
- '53702',
- '53703',
- '53704',
- '53IDM',
- '53401',
- '53402',
- '53403',
- '53404',
- 'JTBN',
- '43',
- '43FBB',
- '43700',
- '43730',
- '43740',
- '43760',
- '43770',
- '43FBT',
- '43500',
- '43530',
- '43550',
- '43570',
- '43KPG',
- '43100',
- '43110',
- '43130',
- '43150',
- '43160',
- '43180',
- '43190',
- '43SMB',
- '43300',
- '43350',
- '43380',
- '44',
- '44BIM',
- '44300',
- '44310',
- '44320',
- '44330',
- '44340',
- '44MTR',
- '44110',
- '44120',
- '44130',
- '44140',
- '44150',
- '44160',
- '44SBW',
- '44200',
- '44210',
- '44220',
- '44230',
- '44240',
- '51',
- '51BJN',
- '51801',
- '51802',
- '51803',
- '51804',
- '51805',
- '51806',
- '51807',
- '51808',
- '51BWG',
- '51670',
- '51671',
- '51672',
- '51673',
- '51675',
- '51GSK',
- '51120',
- '51121',
- '51122',
- '51123',
- '51JBR',
- '51601',
- '51602',
- '51603',
- '51604',
- '51605',
- '51606',
- '51607',
- '51608',
- '51609',
- '51KDR',
- '51401',
- '51402',
- '51403',
- '51404',
- '51405',
- '51406',
- '51408',
- '51409',
- '51410',
- '51411',
- '51412',
- '51MDN',
- '51501',
- '51503',
- '51504',
- '51505',
- '51507',
- '51508',
- '51509',
- '51MJK',
- '51450',
- '51452',
- '51453',
- '51454',
- '51455',
- '51456',
- '51457',
- '51458',
- '51459',
- '51460',
- '51MLG',
- '51301',
- '51302',
- '51303',
- '51304',
- '51305',
- '51306',
- '51307',
- '51308',
- '51309',
- '51310',
- '51311',
- '51312',
- '51313',
- '51314',
- '51PMK',
- '51700',
- '51710',
- '51720',
- '51730',
- '51740',
- '51750',
- '51760',
- '51770',
- '51780',
- '51790',
- '51715',
- '51PON',
- '51540',
- '51541',
- '51542',
- '51543',
- '51PSR',
- '51350',
- '51351',
- '51352',
- '51353',
- '51354',
- '51355',
- '51356',
- '51357',
- '51358',
- '51SBB',
- '51161',
- '51162',
- '51163',
- '51SBS',
- '51140',
- '51141',
- '51142',
- '51143',
- '51146',
- '51SBU',
- '51101',
- '51102',
- '51103',
- '51104',
- '51105',
- '51106',
- '51SDA',
- '51180',
- '51181',
- '51182',
- '51STB',
- '51650',
- '51651',
- '51652',
- '51653',
- '51654',
- '55',
- '55JTM',
- '55400',
- '55410',
- '55420',
- '55SLT',
- '55100',
- '55110',
- '55120',
- '55130',
- '55140',
- '55TMR',
- '55200',
- '55210',
- '55220',
- '55230',
- '55UTR',
- '55300',
- '55310',
- '55320',
- '55330',
- '55340',
- 'KAL',
- '21',
- '21KTP',
- '21400',
- '21410',
- '21420',
- '21430',
- '21PTK',
- '21100',
- '21101',
- '21102',
- '21110',
- '21120',
- '21121',
- '21140',
- '21SGU',
- '21300',
- '21310',
- '21330',
- '21360',
- '21370',
- '21380',
- '21SKW',
- '21200',
- '21210',
- '21220',
- '21230',
- '21240',
- '21250',
- '22',
- '22BJM',
- '22100',
- '22110',
- '22120',
- '22130',
- '22140',
- '22150',
- '22160',
- '22BRB',
- '22200',
- '22210',
- '22220',
- '22230',
- '22240',
- '22250',
- '22260',
- '22270',
- '22KKP',
- '22500',
- '22510',
- '22520',
- '22530',
- '22540',
- '22550',
- '22KTB',
- '22300',
- '22320',
- '22330',
- '22PRY',
- '22400',
- '22410',
- '22420',
- '22430',
- '22440',
- '22450',
- '22460',
- '22470',
- '22480',
- '23',
- '23BPN',
- '23200',
- '23201',
- '23211',
- '23220',
- '23222',
- '23230',
- '23BRU',
- '23300',
- '23320',
- '23350',
- '23360',
- '23BTG',
- '23400',
- '23420',
- '23SMD',
- '23100',
- '23102',
- '23112',
- '23120',
- '23141',
- '23156',
- '23157',
- '23TRK',
- '23500',
- 'SUL',
- '31',
- '31100',
- '31101',
- '31102',
- '31110',
- '31120',
- '31130',
- '31140',
- '31150',
- '31160',
- '31170',
- '31180',
- '31190',
- '31200',
- '31210',
- '31211',
- '31220',
- '31230',
- '31240',
- '31250',
- '31260',
- '31270',
- '31280',
- '31290',
- '31500',
- '31501',
- '31520',
- '31530',
- '31540',
- '31550',
- '31600',
- '31601',
- '31610',
- '31620',
- '31630',
- '31650',
- '31700',
- '31710',
- '31720',
- '31730',
- '31740',
- '31750',
- '31760',
- '31800',
- '31801',
- '31810',
- '31820',
- '31830',
- '31840',
- '31850',
- '31860',
- '31870',
- '31900',
- '31910',
- '31920',
- '31930',
- '31940',
- '31950',
- '32',
- '32AMS',
- '32111',
- '32121',
- '32131',
- '32141',
- '32151',
- '32161',
- '32AMU',
- '32010',
- '32020',
- '32030',
- '32040',
- '32CBB',
- '32810',
- '32820',
- '32830',
- '32840',
- '32850',
- '32CBK',
- '32710',
- '32720',
- '32730',
- '32740',
- '32750',
- '32760',
- '32770',
- '32CKD',
- '32320',
- '32330',
- '32340',
- '32350',
- '32360',
- '32370',
- '32380',
- '32CMJ',
- '32910',
- '32920',
- '32930',
- '32940',
- '32950',
- '32960',
- '32CPG',
- '32410',
- '32420',
- '32430',
- '32440',
- '32450',
- '32CPL',
- '32610',
- '32620',
- '32630',
- '32640',
- '32650',
- '32660',
- '32680',
- '32CPR',
- '32510',
- '32520',
- '32530',
- '32540',
- '32550',
- '32560',
- '32570',
- '32CWP'
- )
- OR SITE_CODE IN (
- '32210',
- '32240',
- '32250',
- '32260',
- '32270',
- '32280',
- '32MKS',
- '32110',
- '32120',
- '32130',
- '32140',
- '32150',
- '32156',
- '32160',
- '32170',
- '32180',
- '32190',
- 'MP',
- '41',
- '41ABN',
- '41111',
- '41130',
- '41134',
- '41140',
- '41142',
- '41150',
- '41151',
- '41160',
- '41180',
- '41189',
- '41199',
- '41MSH',
- '41410',
- '41420',
- '41430',
- '41440',
- '41450',
- '41SFF',
- '41510',
- '41520',
- '41530',
- '41540',
- '41550',
- '41560',
- '41TAL',
- '41310',
- '41330',
- '41350',
- '41320',
- '41380',
- '41TNT',
- '41210',
- '41220',
- '41230',
- '41260',
- '41280',
- '41290',
- '41291',
- '41292',
- '41TBO',
- '41610',
- '41620',
- '41SLK',
- '41710',
- '41720',
- '42',
- '42BIK',
- '42210',
- '42220',
- '42230',
- '42240',
- '42JYP',
- '42110',
- '42120',
- '42130',
- '42140',
- '42150',
- '42160',
- '42170',
- '42180',
- '42MNK',
- '42410',
- '42420',
- '42430',
- '42440',
- '42450',
- '42MRK',
- '42510',
- '42520',
- '42530',
- '42540',
- '42550',
- '42SOR',
- '42310',
- '42320',
- '42330',
- '42340',
- '42350',
- '42360',
- '42370',
- '42TMK',
- '42610',
- '42620',
- '42630',
- '42NBR',
- '42710',
- '42720',
- '42WMN',
- '42810',
- '42820',
- 'PST'
- ))
- AND JUMLAH BETWEEN 7
- AND 9
- )
- WHERE
- RN BETWEEN ((( 1-1 ) * 100 ) + 1 )
- AND ( 1 * 100 )
- ORDER BY
- RN
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement