I want to use a query which allows me to get two differents results on depending on the filtre. I have tried this one but it does not work.
CASE WHEN filtre = 10
THEN
(
select sum(s.MONTANT_CREANCE_EMP) as creances_emp , s.ANNEE as annee from sc01_emp s
)
ELSE
(
select sum(s.NOMBRE_CREANCE) as creances_emp , s.ANNEE as annee from sc01_emp s
)
END
Thanks all.
try