SQL

CUBE+GROUP BY for Subtotals

In: SQL

We all have used GROUP BY, but do you know CUBE?

For example, if I have a table of user spending, I can get the subtotal of each user AND the total spend of all users combined, all within one table.

πŸ“Œ Syntax is here.
πš‚π™΄π™»π™΄π™²πšƒ
πšžπšœπšŽπš›_πš’πš, πš‚πš„π™Ό(πšœπš™πšŽπš—πš) πšŠπš–πš
π™΅πšπ™Ύπ™Ό πšžπšœπšŽπš›πšœ
π™Άπšπ™Ύπš„π™Ώ π™±πšˆ π™²πš„π™±π™΄(πšžπšœπšŽπš›_πš’πš)

This saves you the need to create separate queries for generating the total.

As usual, full example below!

Another similar function is ROLLUP. Can anyone explain the difference between ROLLUP and π˜Ύπ™π˜½π™€?

More from Travis Tang
Use ARRAY_AGG to flatten columns to lists.
SQL

Use ARRAY_AGG to flatten columns to lists.

You need to convert a long table of values into a list? This is the most convenient function. πŸ“Œ Syntax: πš‚π™΄π™»π™΄π™²πšƒ π™°πšπšπ™°πšˆ_𝙰𝙢𝙢(πšŒπš˜πš•πšžπš–πš—) π™΅πšπ™Ύπ™Ό πšπšŠπš‹πš•πšŽ There
Pivot Table (From Long to Wide)
SQL

Pivot Table (From Long to Wide)

Every data scientist, scientist, and engineer should know how to create a pivot table. π™²π™°πš‚π™΄ πš†π™·π™΄π™½ is the best way to do
Great! You’ve successfully signed up.
Welcome back! You've successfully signed in.
You've successfully subscribed to Travis Tang.
Your link has expired.
Success! Check your email for magic link to sign-in.
Success! Your billing info has been updated.
Your billing was not updated.