SQL

SQL

Snippets on basic & advanced functions
13 posts
Use SAFE_DIVIDE to handle division by zero.
SQL

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
CROSS JOIN for all combinations
SQL

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
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.