Oracle - Rollup not working when I use Having clause

[vanandwiz]

Please find the code below.

SELECT
COMPANY.NAME,
COUNT(ITEM.ID)
FROM
ITEM,
COMPANY
WHERE ITEM.COMPANYID = COMPANY.ID
GROUP BY ROLLUP(COMPANY.NAME)
HAVING COMPANY.NAME NOT LIKE 'RESEAR%'
AND COMPANY.NAME NOT LIKE 'LOOK%'
ORDER BY COMPANY.NAME ASC;

when I use the having clause the rollup does not show the sub total. Actually I use the rollup to show the subtotals. Why is not displayed when I use having clause? Is there any other way to get around the problem?

Thanks in advance.

[frozenmist]

Hi,
Welcome to TSDN. I am sure you will find the forums here informational.
I am moving your question from articles section to forums. Please don't post any questions as thread in articles.

MODERATOR