MySQL Forums
Forum List  »  Docs

Re: Group by .. with rollup having
Posted by: Paul DuBois
Date: May 20, 2009 09:30AM

HAVING is not useful with WITH ROLLUP.

http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html:

"Because the NULL values in the super-aggregate rows are placed into the result set at such a late stage in query processing, you cannot test them as NULL values within the query itself. For example, you cannot add HAVING product IS NULL to the query to eliminate from the output all but the super-aggregate rows."

Options: ReplyQuote


Subject
Views
Written By
Posted
29148
August 02, 2006 07:42PM
Re: Group by .. with rollup having
6592
May 20, 2009 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.