Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. SELECT 'Positivação' as SERIE, ANO AS X, clientes_positivados as Y FROM (
  2. SELECT EXTRACT(year FROM pcmov.DTMOV) AS ANO, COUNT(DISTINCT pcclient.codcli) clientes_positivados
  3. FROM pcnfsaid,
  4. pcmov,
  5. pcclient
  6. WHERE pcnfsaid.numtransvenda = pcmov.numtransvenda
  7. AND pcnfsaid.dtcancel IS NULL
  8. AND pcclient.codcli = pcmov.codprod
  9. AND pcclient.dtexclusao IS NULL
  10. AND nvl(pcnfsaid.tipovenda, 'X') NOT IN ('SR', 'DF')
  11. GROUP BY EXTRACT(year FROM pcmov.DTMOV)
  12. ) Q
  13. UNION
  14. SELECT 'TESTE' as SERIE, 2013 AS X, 50 AS Y FROM DUAL
  15. UNION
  16. SELECT 'TESTE' as SERIE, 2014 AS X, 60 AS Y FROM DUAL
  17. UNION
  18. SELECT 'TESTE' as SERIE, 2015 AS X, 70 AS Y FROM DUAL
  19. UNION
  20. SELECT 'TESTE' as SERIE, 2016 AS X, 80 AS Y FROM DUAL
  21. UNION
  22. SELECT 'TESTE' as SERIE, 2017 AS X, 50 AS Y FROM DUAL
  23. UNION
  24. SELECT 'TESTE' as SERIE, 2018 AS X, 60 AS Y FROM DUAL
  25. UNION
  26. SELECT 'TESTE' as SERIE, 2019 AS X, 70 AS Y FROM DUAL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement