Group By problem

[Guest_imported]

I have a table which columns like "category", "Amount" and some other half a dozen columns.
i want an SQL query which will select ALL the columns of the table ..grouped by "category" and giving Sum of "Amount" for that category.

Desired op shud be like this :

"Category" "Amount" "SumAmountsbycategory" col3
A 100 150

A 50 150

B 20 60

B 40 60
Can any one help me ?

 

[tlbroadbent]

Select
Category, Amount,
SumAmountsByCategory=
(Select Sum(Amount) From Table
Where Category = a.Category),
col3, col4, ....
From Table a Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.