Old problem! Don't laugh!
SELECT SETTLEID FROM (SELECT SETTLLEID
From electronicaccept e
Where userStateID = 'u'
GROUP BY settleId
Order by Sum (NVL (E.Allcapacity, 0)) DESC)
WHERE ROWNUM
