1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT s.nummatric, s.nom, s.prenom,
sum(case when r.sens='+' then e.montant else NULL end) "PAYE",
sum(case when r.sens='-' then e.montant else NULL end) "RETENU",
sum(case when r.sens='+' then e.montant else NULL end)
-
sum(case when r.sens='-' then e.montant else NULL end) "SALAIRE"
FROM rubrique r, elements e, salarie s
WHERE e.norubrique=r.norubrique
AND e.nummatric=s.nummatric
HAVING
( sum(case when r.sens='+' then e.montant else NULL end)
- sum(case when r.sens='-' then e.montant else NULL end) )
> 0
GROUP BY s.nom, s.prenom, s.nummatric; |