--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> Hi !
>
> I think there is a bunch of ways to solve this, one is this:
>
> select
> Date,
> sum(Case when Status = '1' then 1 else 0 end),
> sum(Case when Status = '2' then 1 else 0 end),
> sum(Case when Status = '3' then 1 else 0 end)
> from
> PedidoVenda
> group by
> 1
>
> got it ?
>
> see you !
>

i got it! thank you!