econz icon

Firebird - Curva ABC

econz | PRO | 07/17/19 05:33:27 PM UTC | 0 ⭐ | 7128 👁️ | Never ⏰ | []
SQL |

530 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    • 
            
            
  • 
                
    
                    
    
                         icon
                    
    
                    
    
                        
                        
                        
                    
    
                    
    
                        
                        01/01/70 12:00:00 AM UTC
                        
                    
    
                
    
                

    
    
    
        
    
            Plain Text
            |
            
    0 B
    
            
            |
            
     👍
    
            /
            
     👎
    
        
    
        
    
    
    
    
        
    
    
    

    

            
    •