Use EXISTS to check if a row is present
Need to find if records from table A can also be found in table B? EXISTS is here to help.
1 min read
SQL
Snippets on basic & advanced functions
13 posts
The SIGN function
Use SIGN to see if a number is positive, negative, or zero.
It's as simple as it sounds.
Apply SIGN(
1 min read
Use SAFE_DIVIDE to handle division by zero.
ππΌππ_πΏππππΏπ divides two numbers while handling the case where the denominator is zero.
π Here's the syntax.
ππ΄π»π΄π²π ππ°π΅π΄_π³πΈπ
πΈπ³π΄(πππππππππ, πππππππππππ) π΅ππΎπΌ πππππππ
If the denominator is zero
CUBE+GROUP BY for Subtotals
We all have used GROUP BY, but do you know CUBE?
For example, if I have a table of user
Get subtotals with ROLLUP+GROUP BY
ππππππ generates extra rows that represent the subtotals.
For exampleβ¦
To get the sum of spending of each user, you typically
1 min read
CROSS JOIN for all combinations
It is the cartesian products of both tables, if you're a math nerd.
π Syntax:
ππ΄π»π΄π²π *
π΅ππΎπΌ πππππ_π·
π²ππΎππ πΉπΎπΈπ½ πππππ_πΈ
Note that there is no need
1 min read