Hi , I have this code :
select i.INVESTOR_CODE ,
i.investor_name ,
sum(invoice_commission) as commission ,
sum(INVOICE_SUBTOTAL) as total <<<<
from investor i , invoice inv
where INVOICE_DATE between '01-JAN-08' and '31-DEC-08'
and i.INVESTOR_CODE = inv.INVESTOR_CODE
group by i.INVESTOR_CODE , i.investor_name
order by total;
Can someone PLEASE re-write this query so it can get the top 100 investor with the highest "total"
Thanks....