Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

sql OLAP type group by roll up

Home
Forums
SQL

sql OLAP type group by roll up

Guest User

5yAsked Nov 5, 2020, 8:48 PM1.1kSQL

Newbie here

I can't figure out what sql query entry

hope someone can help me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Amit Mohanty5y ago
Accepted answer
Hey, try this
DECLARE @SaleTotal TABLE
(
    MonthNo INT,
    Brand NVARCHAR(50),
    TotalAmt NUMERIC(18,2)
)
INSERT INTO @SaleTotal
SELECT MONTH(PurchaseDate),ISNULL(Brand,'Month Total'),SUM(Price)
FROM SaleLogs GROUP BY MONTH(PurchaseDate), ROLLUP (Brand)

SELECT MonthNo,Brand,TotalAmt FROM @SaleTotal
UNION ALL
SELECT NULL,'Grand Total',SUM(TotalAmt) FROM @SaleTotal WHERE Brand = 'Month Total'
Guest User5y ago
This output must be group by cube operator..
Guest User5y ago
TY @Amit Mohanty it work but i'm gonna check how it happen