Rollup on just some columns
from the Artful Common Queries page
In an aggregating query using
ROLLUP
, suppress Rollup in a given
colname
with
HAVING !ISNULL{colname)
.
Last updated 9 Aug 2024
</td></tr></table> <div style="float-left;display:inline-block;width:100%;"><br><br><hr></div><center><div style="color:#990000;display:inline-block;"><b><i>Return to <a href="../infotree/queries.html">the Artful Common Queries page</a></i></b></div></center><span style="float-left;"><hr></span><script type="text/javascript">new Image().src = "//counter.yadro.ru/hit?r"+escape(document.referrer)+((typeof(screen)=="undefined")?"":";s"+screen.width+"*"+screen.height+"*"+(screen.colorDepth?screen.colorDepth:screen.pixelDepth))+";u"+escape(document.URL)+";"+Math.random();</script> </body> </html>
