sql having

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