| Subject | Re: Convert DBISAM Sql to Firebird Sql |
|---|---|
| Author | legrand_legrand_63 |
| Post date | 2006-12-02T20:23:35Z |
Could you try this ?
Select Numero,
Sum(case concepto when 1 then cast(valor as float) else cast(0 as
float) end)
as Val1,
Sum(case concepto when 80 then cast(valor as float) else cast(0 as
float) end)
as Val80,
Sum(case concepto when 85 then cast(valor as float) else cast(0 as
float) end)
as Val85
From Movtos
group by numero
Regards
PAscal
Select Numero,
Sum(case concepto when 1 then cast(valor as float) else cast(0 as
float) end)
as Val1,
Sum(case concepto when 80 then cast(valor as float) else cast(0 as
float) end)
as Val80,
Sum(case concepto when 85 then cast(valor as float) else cast(0 as
float) end)
as Val85
From Movtos
group by numero
Regards
PAscal