Advertisement
econz

Firebird - Curva ABC

Jul 17th, 2019
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. SELECT
  2.    DISTINCT
  3.    PED.CODPESSOA,
  4.    PES.NOME,
  5.    (SUM(PED.TOTALLIQB) OVER()) AS TOTAL,
  6.    (SUM(PED.TOTALLIQB) OVER (partition BY PED.CODPESSOA)) AS TOTAL_PESSOA ,
  7.    ((SUM(PED.TOTALLIQB) OVER (partition BY PED.CODPESSOA)) / (SUM(PED.TOTALLIQB) OVER()) * 100) AS PERC
  8. FROM PEDIDO PED
  9. INNER JOIN PESSOA PES ON PES.CODPESSOA=PED.CODPESSOA
  10. WHERE
  11.    PED.DATA BETWEEN '01/01/2019' AND '12/31/2019'
  12.    AND PED.SOMAFAT = 'S'
  13.    AND PED.TIPOMOV = 'S'
  14.    AND PED.TOTALLIQB > 0
  15. ORDER BY
  16.    TOTAL_PESSOA DESC, PES.NOME, PED.CODPESSOA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement