select * from (
SELECT fund_id, sum(dividend_amt) tt
FROM FUND_DIVIDENDS FD1
group by fund_id
having sum(dividend_amt) >600
order by sum(dividend_amt) desc
)
where rownum <=5
table: account / subject / score
select records, sum of score is more than 500
select account, sum(score) from t
group by account
having sum(score) > 500
subject top ten
select * from t2 where
(
select count(1) from t1 where t1.score > t2.score and t1.subject=t2.subject
) <= 10