Hi all,
I have a table, let say Tbl1, which structure something like this
id_cst int, id_gd int, qty int.
I want to select from that table, all records that has sum(qty) > 0 group by
id_cst and id_gd.
I have 2 options to do that :
1) create a view with a ddl like this :
create view tmp (id_
Sugi,
> I have a table, let say Tbl1, which structure something like this id_cst int,
> id_gd int, qty int.
>
> I want to select from that table, all records that has sum(qty) > 0 group by
> id_cst and id_gd.
>
> I have 2 options to do that :
> 1) create a view with a ddl like this :
>create
On Tue, Oct 30, 2012 at 12:19 AM, trskopo wrote:
>
> I want to select from that table, all records that has sum(qty) > 0 group
> by id_cst and id_gd.
>
> I have 2 options to do that :
> 1) create a view with a ddl like this :
>create view tmp (id_cst, id_gd, qty) as
>select id