Adding Unique data

8 Jun 2006 8:50 PM

Selvarathinam

Dear Folks,

I have a table like

Invno      Amount
55             100
55             200
56              50
57             150
57             300
57               50

I need to query to make it as

55      -      300
56      -        50
57      -       500

Please help me....

Thanks for your replies in advance.

Regards,
Selvarathinam.

8 Jun 2006 8:54 PM

Tracy McKibben

SELECT InvNo, SUM(Amount)
FROM Table
GROUP BY InvNo

Selvarathinam wrote:
Show quote

> Dear Folks,
>
> I have a table like
>
> Invno      Amount
> 55             100
> 55             200
> 56              50
> 57             150
> 57             300
> 57               50
>
> I need to query to make it as
>
> 55      -      300
> 56      -        50
> 57      -       500
>
> Please help me....
>
> Thanks for your replies in advance.
>
> Regards,
> Selvarathinam.

8 Jun 2006 9:07 PM

Selvarathinam

Thanks a ton....

itz working

Tracy McKibben wrote:

Show quote

> SELECT InvNo, SUM(Amount)
> FROM Table
> GROUP BY InvNo
>
>
> Selvarathinam wrote:
> > Dear Folks,
> >
> > I have a table like
> >
> > Invno      Amount
> > 55             100
> > 55             200
> > 56              50
> > 57             150
> > 57             300
> > 57               50
> >
> > I need to query to make it as
> >
> > 55      -      300
> > 56      -        50
> > 57      -       500
> >
> > Please help me....
> >
> > Thanks for your replies in advance.
> >
> > Regards,
> > Selvarathinam.

8 Jun 2006 8:55 PM

Tony Murnion

Select invno, sum(amount) group by invno

Show quote

"Selvarathinam" <s.selvarathi***@gmail.com> wrote in message
news:1149799832.127814.236410@y43g2000cwc.googlegroups.com...
> Dear Folks,
>
> I have a table like
>
> Invno      Amount
> 55             100
> 55             200
> 56              50
> 57             150
> 57             300
> 57               50
>
> I need to query to make it as
>
> 55      -      300
> 56      -        50
> 57      -       500
>
> Please help me....
>
> Thanks for your replies in advance.
>
> Regards,
> Selvarathinam.
>