select * from

(select t.symbol, sum(vol) from xxxx.trade t, sym.symbol s where trunc(trade_time) > trunc(sysdate)

and t.symbol=s.symbol and nvl(s.test_symbol,0)<>1

and s.sector = 'Materials'

group by t.symbol order by 2 DESC)

where rownum <= 5;

(select t.symbol, sum(vol) from xxxx.trade t, sym.symbol s where trunc(trade_time) > trunc(sysdate)

and t.symbol=s.symbol and nvl(s.test_symbol,0)<>1

and s.sector = 'Materials'

group by t.symbol order by 2 DESC)

where rownum <= 5;