Re: [oracle_br] Resultado lado á lado

Thu, 04 Sep 2014 12:48:54 -0700 

OPA, faltou truncar a data no agrupamento e extender para aceitar os registros 
recebidos até as 23:59 do ultimo dia.

SELECT trunc(DTSAIDA,)
       SUM(CASE when upper(nvl(substr(regexp_replace(SERIE, 
'[[:punct:]]|[[:blank:]]|[0-9]'),1,2),'xx'))  = 'CF' THEN VLTOTAL ELSE 0 END) 
CF,
       SUM(CASE when upper(nvl(substr(regexp_replace(SERIE, 
'[[:punct:]]|[[:blank:]]|[0-9]'),1,2),'xx')) != 'CF' THEN VLTOTAL ELSE 0 END) 
NOCF
  FROM PCNFSAID N
 WHERE 1 = 1
   AND DTSAIDA BETWEEN to_date('01/SEP/2014', 'DD/MON/YYYY') AND 
TO_DATE('10/SEP/2014', 'DD/MON/YYYY')+0.99999
 GROUP BY trunc(DTSAIDA)
 ORDER BY 1;


Ederson Elias 
DBA Oracle - http://br.linkedin.com/pub/ederson-elias/24/8b/8b0
------------ Labor improbus omnia vincit

Responder a