在同一张表上获得不同ID的最高值？

Question

我有标书表，每个出价都有数量和AuctionID。

我想和/从每个AuctionID中选择所有最高的出价。

示例：

其结果是：

SELECT AuctionID,Amount, Highest FROM Bids Where Burned=0 ORDER BY Amount DESC

AuctionID   Amount  Highest
   1       44.4400     0
   3       43.7800     0
   2       42.3300     0
   1       22.2200     0
   4       21.2700     0
   1       21.2600     0
   4       21.2500     0
   2       21.2400     0
   1       12.6600     0
   4       12.5200     0

它应该返回44.44，43.78，42.33，21.27。

“最高”是一个我认为可能有用的旗子，它仍然没有用。我想看看是否有一种不用国旗的方法。

Answer 1

得到所有最高的出价：

Select auctionid, max(amount) from auctions group by auctionid

要获得最高出价的总金额：

select sum(v1.max_amount) from
(Select auctionid, max(amount) max_amount from auctions group by auctionid
) as v1

Answer 2

一个简单的组逐个子句就可以做到这一点：

select AuctionID, MAX(Amount)
from table
group by AuctionID

Answer 3

SELECT AuctionId, MAX(Amount) FROM TableName GROUP BY AuctionID