SQL (Rollup and Having)!

[CW1]

Hello!<br>Who can help me?<br>Sorry but my english is not so good. I have a small problem.<br>My Select:<br>&quot;Select Fb, SUM(Wert) as Wert WHERE ... GROUP BY Fb WITH ROLLUP HAVING SUM(Wert) between 100000 and 200000 ORDER BY Fb&quot;<br>Result:<br>001 100012<br>003 199999 ....<br><br>Without ROLLUP I become a record with&nbsp;&nbsp;NULL and a SUM.<br>What can I do, that i become the NULL - Value from the ROLLUP function. I need a SUM about all the resultrecord's.<br>Thank's<br><br>

 

[bigscouse]

Why do you want to sum nulls, they have no value to sum? <p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>

 

[CW1]

Sorry but by description was not so good!<br>I will not sum nulls. I think my problem cannot work with HAVING and ROLLUP because HAVING exclude the Group - Sums.<br>Two example's:<br>1. Select Fb, Sum(Wert) WHERE... Group By Fb with Rollup<br>Result: 001&nbsp;&nbsp;100.000<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;002&nbsp;&nbsp;150.000<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NULL 200.000<br>2. Select Fb, Sum(Wert) WHERE... Group By Fb with Rollup&nbsp;&nbsp;HAVING SUM (Wert) between 120.000 and 170.000<br>Result: 002&nbsp;&nbsp;150.000<br><br>I think, that the function ROLLUP execute after the function Having. But this is not correct. <br><br>I need the result:<br>002&nbsp;&nbsp;150.000<br>NULL 150.000<br>The select must be always the same.<br><br>