adspace


what are rollup and cube in t-sql? : Transact sql

Answer Posted / Vaneet Parkash

Rollup and Cube are aggregate functions in T-SQL used for grouping and summarizing data. Rollup generates a summary row for each group, including the total of all groups. Cube generates a pivot table that displays cross-tabulated group results.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many tables will create when we create table, what are they? : Sql dba

1155


What is the current version of sql?

1106


What is the current version of postgresql?

1188


what are aggregate and scalar functions? : Sql dba

1142


How do I remove duplicates in two columns?

1202


If a cursor is open, how can we find in a pl/sql block?

1252


Can we use distinct and group by together?

1146


Can we rollback truncate?

1083


Does group by remove duplicates?

1120


what is bcp? When does it used? : Sql dba

1065


What is your daily office routine?

2353


how to start mysql server? : Sql dba

1279


Is primary key always clustered index?

1101


how to use regular expression in pattern match conditions? : Sql dba

1125


Is primary key clustered index?

1028