Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*)
- FROM DTEC_COMUNICACAO_CPE DCC
- JOIN DTEC_CIENTE_ELETRONICO DCE ON DCC.DCC_DCE_ID_COMUNIC = DCE.DCE_DCE_ID_COMUNIC AND DCC.DCC_DCR_ID_CPE = DCE.DCE_DCR_ID_CPE
- JOIN DTEC_ACESSO_CPE DAC ON DAC.DTA_ID_CPE = DCE.DCE_DCR_ID_CPE
- WHERE TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymm') = '201906'
- AND TO_CHAR(DAC.DTA_DATA, 'yyyymmdd') >= TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymmdd')
- AND TO_CHAR(DAC.DTA_DATA, 'yyyymmdd') <= TO_CHAR(DCC.DCC_DATA_LEITURA, 'yyyymmdd')
- AND DCE.DCE_DCE_ID_ESTADO_CIENTE = 3
- AND NOT EXISTS(
- SELECT *
- FROM DTEC_ACESSO_CPE DAC2
- WHERE DAC2.DTA_ID_CPE = DCE.DCE_DCR_ID_CPE
- AND TO_CHAR(DAC2.DTA_DATA, 'yyyymmdd') >= TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymmdd')
- AND TO_CHAR(DAC2.DTA_DATA, 'yyyymmdd') < TO_CHAR(DAC.DTA_DATA, 'yyyymmdd') )
- ORDER BY DAC.DTA_DATA;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement