Archives of the TeradataForum

Message Posted: Tue, 11 Dec 2012 @ 23:04:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Adding a null column () to GROUP BY GROUPING SETS will produce

* salary totals of each department

* a grand total of all departments

	<Prev	Next>		<<First	<Prev	Next>	Last>>