[firebase-br] Ajuda com SQL

[Hélio Oliveira]

Boa tarde André!

Muito obrigado... agora foi.

select count(x.matricula)     as total_funcionarios,
         sum(x.bc_irrf)         as base_irrf,
         sum(x.qtde_dep_ir)     as qtde_dep_ir,
         sum(x.bc_inss)         as base_inss,
         sum(x.bc_prev_propria) as base_prev_propria,
         sum(x.bc_fgts)         as base_fgts,
         sum(x.vencimentos)     as total_vencimentos,
         sum(x.descontos)       as total_descontos,
         sum(x.liquido)         as total_liquido,
         (select sum(z.valor)
          from folha z
            join folha_base w on (w.matricula = z.matricula
                              and w.mes = z.mes
                              and w.ano = z.ano
                              and w.sequencia = z.sequencia)
            join divisao dv on (dv.cod_divisao = w.cod_divisao)
          where w.mes       = 1
            and w.ano       = 2011
            and w.sequencia = 0
            and dv.cod_secretaria in (1)
            and z.cod_evento in (2, 3)) as Sal_FM
from folha_base x
    join divisao dv on (dv.cod_divisao = x.cod_divisao)
where x.mes       = 1
    and x.ano       = 2011
    and x.sequencia = 0
    and dv.cod_secretaria in (1)
group by dv.cod_secretaria


-- 
[]'s,

Hélio Oliveira
Bel. Ciência da Computação
Técnico em Contabilidade
e-mail : hpensador em gmail.com
Skype : hpensador
http://hpensador.blogspot.com/
www.hpensador.net
(71) 9975-9176