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 = A.SITE_CODE AND SITE_TYPE_ID = 5 ) SITE_NAME,
- METER_CODE,
- METER_TYPE_BRAND,
- LOCATION_CODE,
- LOCATION_NAME,
- TARIFF,
- POWER,
- SUSPECT_CATEGORY,
- ROUND( VOLTAGE_L1, 2 ),
- ROUND( VOLTAGE_L2, 2 ),
- ROUND( VOLTAGE_L3, 2 ),
- ROUND( VOLTAGE_ANGLE_L1, 2 ),
- ROUND( VOLTAGE_ANGLE_L2, 2 ),
- ROUND( VOLTAGE_ANGLE_L3, 2 ),
- ROUND( CURRENT_L1, 2 ),
- ROUND( CURRENT_L2, 2 ),
- ROUND( CURRENT_L3, 2 ),
- CURRENT_N,
- ROUND( CURRENT_ANGLE_L1, 2 ),
- ROUND( CURRENT_ANGLE_L2, 2 ),
- ROUND( CURRENT_ANGLE_L3, 2 ),
- ROUND( POWER_FACTOR_L1, 2 ),
- ROUND( POWER_FACTOR_L2, 2 ),
- ROUND( POWER_FACTOR_L3, 2 ),
- ROUND( ACTIVE_POWER_L1, 2 ),
- ROUND( ACTIVE_POWER_L2, 2 ),
- ROUND( ACTIVE_POWER_L3, 2 ),
- (( READ_DATE - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) READ_DATE,
- ROW_NUMBER () OVER ( ORDER BY READ_DATE ASC ) RN,
- MAX( ROWNUM ) OVER ( ORDER BY NULL ) CNT,
- (( SERVER_TIME - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) SERVER_TIME,
- (( METER_TIME - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) METER_TIME,
- ABS(
- FLOOR(( SERVER_TIME - METER_TIME ) * 1440 )) SELISIH
- FROM
- (
- SELECT
- A.SITE_CODE,
- A.METER_CODE,
- A.METER_TYPE_BRAND,
- A.LOCATION_CODE,
- A.LOCATION_NAME,
- A.TARIFF,
- A.POWER,
- A.SUSPECT_CATEGORY,
- A.VOLTAGE_L1,
- A.VOLTAGE_L2,
- A.VOLTAGE_L3,
- A.VOLTAGE_ANGLE_L1,
- A.VOLTAGE_ANGLE_L2,
- A.VOLTAGE_ANGLE_L3,
- A.CURRENT_L1,
- A.CURRENT_L2,
- A.CURRENT_L3,
- A.CURRENT_N,
- A.CURRENT_ANGLE_L1,
- A.CURRENT_ANGLE_L2,
- A.CURRENT_ANGLE_L3,
- A.POWER_FACTOR_L1,
- A.POWER_FACTOR_L2,
- A.POWER_FACTOR_L3,
- A.ACTIVE_POWER_L1,
- A.ACTIVE_POWER_L2,
- A.ACTIVE_POWER_L3,
- A.READ_DATE,
- B.SERVER_TIME,
- B.METER_TIME
- FROM
- SUSPECT_INSTANTS A
- LEFT JOIN TRANS_INSTANT B ON A.LOCATION_CODE = B.LOCATION_CODE
- WHERE
- A.SUSPECT_CATEGORY = '7'
- AND A.DATE_READ BETWEEN '20190601'
- AND '20190630'
- ) A
- WHERE
- LOCATION_CODE = '534252570394'
- )
- WHERE
- RN BETWEEN ((( 1-1 ) * 100 ) + 1 )
- AND ( 1 * 100 )
- ORDER BY
- RN
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement