Query oracle

[huesos52]

Entiendo!!

Prueba esto:

Código SQL:

SELECT ASSETNUM, TOTALCOST FROM ASSET
  WHERE ASSETNUM LIKE 'H%' AND TOTALCOST!=0 AND ROWNUM <=5 
  GROUP BY  ASSETNUM,TOTALCOST
  HAVING SUM(TOTALCOST)>200
UNION
SELECT 'TOTAL',SUM(TOTALCOST) FROM ASSET
  WHERE ASSETNUM LIKE 'H%' AND TOTALCOST!=0 AND ROWNUM <=5 
  HAVING SUM(TOTALCOST)>200;