All pastes #903285 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-14 03:46 UTC
rendered paste body
SELECT domains.domain, a.amount 
FROM domains 
INNER JOIN bids a
ON domains.id = a.domain 
Where bids.amount in 
(select top 1 b.amount from bids b where b.amount = a.amount  order by amount desc)
ORDER BY amount DESC