I am using with rollup
in my sql query. I am not getting alias name for rollup.
My SQL is
SELECT [Column1],
sum([Column2])
FROM Tablea
GROUP BY [Column2] WITH ROLLUP
Which returns
s 8
t 8
j 8
null 24
How can I replace the NULL
in the total row?
The basic syntax of a table alias is as follows. SELECT column1, column2.... FROM table_name AS alias_name WHERE [condition];
SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of that query. An alias is created with the AS keyword.
Introduction to SQL ROLLUP The ROLLUP is an extension of the GROUP BY clause. The ROLLUP option allows you to include extra rows that represent the subtotals, which are commonly referred to as super-aggregate rows, along with the grand total row.
You can use the GROUPING
function in a CASE
expression.
SELECT CASE
WHEN GROUPING([Column1]) = 1 THEN 'Total'
ELSE [Column1]
END [Column1],
sum([Column2])
FROM Tablea
GROUP BY [Column1] WITH ROLLUP
SQL Fiddle
select
isnull([column1],'rollup'),
sum([column2] )
from tableA
group by [column1]
WITH ROLLUP
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With