Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- DISTINCT
- PED.CODPESSOA,
- PES.NOME,
- (SUM(PED.TOTALLIQB) OVER()) AS TOTAL,
- (SUM(PED.TOTALLIQB) OVER (partition BY PED.CODPESSOA)) AS TOTAL_PESSOA ,
- ((SUM(PED.TOTALLIQB) OVER (partition BY PED.CODPESSOA)) / (SUM(PED.TOTALLIQB) OVER()) * 100) AS PERC
- FROM PEDIDO PED
- INNER JOIN PESSOA PES ON PES.CODPESSOA=PED.CODPESSOA
- WHERE
- PED.DATA BETWEEN '01/01/2019' AND '12/31/2019'
- AND PED.SOMAFAT = 'S'
- AND PED.TIPOMOV = 'S'
- AND PED.TOTALLIQB > 0
- ORDER BY
- TOTAL_PESSOA DESC, PES.NOME, PED.CODPESSOA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement