SQL Server : Group By Price and Sum Amount

Question

I have a table like this:

Id	Type	Price	Amount
4284627	sell	307.800000	27.390000
4284640	sell	307.800000	2.670000
4284681	buy	307.600000	0.480000
4284682	buy	307.600000	1.960000

And I am trying to get following result: 2 rows, sum amount of same prices.

Id	Type	Price	Amount
4284627	sell	307.800000	30.06
4284681	buy	307.600000	2.44

Can anyone point me to right direction please?

Why do you need ID column in result ? it seems meaninglees since you aggregate the others. — Ali Fidanli, Sep 21 '21 at 12:00
Just looks like a `SUM` and `MIN` to me. Neither of these are particularly difficult concepts in SQL. — Thom A, Sep 21 '21 at 12:00
Reasoning is this: i need to show how many ( amount ) sell orders or buy orders in the system by the price. I don't need ID in the result but i need to order by last to first, so Id. — Orhan Kalayci, Sep 21 '21 at 12:24

score 1 · Accepted Answer · answered Sep 21 '21 at 12:01

1

You seem to want to group by type as well:

select min(id), type, price, sum(amount)
from t
group by type, price;

But for your question, this works:

select min(id), min(type), price, sum(amount)
from t
group by price;

answered Sep 21 '21 at 12:01

Gordon Linoff

1 Answers1