SQL Server : Group By Price and Sum Amount

Question

我有一个这样的表:

<表类> Id 类型 价格金额tbody><<tr>4284627销售307.80000027.3900004284640卖307.8000002.6700004284681买307.6000000.4800004284682买307.6000001.960000

您似乎也想按type分组:

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

但对于你的问题，这是有效的:

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