Snowflake Vs MS-SQL - Part 60 - Divide by Zero

      



Divide by Zero

Sometimes in calculation, if zero comes at the denominator place, it throws an error like Divide by Zero.


 MS-SQL Server 

You can find the workaround as below:



However, in Snowflake we can use DIV0 as below.




For more details, you can refer to the following DIV0 and DIV0NULL.


  

Comments

Post a Comment

Popular posts from this blog

Snowflake Vs MS-SQL - Series

Image
Snowflake Vs MS-SQL - Series Part 107 -  Create or Alter Table - Add Column -  Part 107 Part 106 - Table Structure - Describe - Part 106 Part 105 - PIVOT - Custom alias to column name - Part 105 Part 104 - Row Comparison - HASH - Part 104 Part 103 - ORDER BY ALL - SORTING - Part 103 Part 102 - Last Value in the Series - Part 102 Part 101 - Trigonometry Functions - Geometry - Part 101 Part 100 - Split String into Different Columns - Part 100 Part 99 - Multi-Table Insert based on condition - Part 99 Part 98 -  Create Table If Not Exists - Part 98 Part 97 - Identify Data Type - SYSTEM$TYPEOF - Part 97 Part 96 -  Row Last Updated - ROW_TIMESTAMP   -  Part 96 Part 95 -  Date and Time - INTERVAL   -  Part 95 Part 94 -  BOOLAND_AGG   -  Part 94 Part 93 -  MERGE ALL BY NAME   -  Part 93 Part 92 -  Stop or Cancel the Running Query   -  Part 92 Part 91 -  ARRAY UNNEST - FLATTEN   -  Part ...
Read more

Snowflake Vs MS-SQL - Part 79 - Adding a comment to the Column of a Table

Image
            Adding a comment to the Column of a Table Suppose you are designing a new table, and you want to add a comment for the columns of that table, so that whoever uses this table will get some idea of the columns of this table. MS-SQL Server   We can achieve it by using a system-level stored procedure( sp_addExtendedProperty ), which uses Extended properties to allow you to store custom metadata: In  Snowflake,  we can use a similar approach by using the  COMMENT  clause as  below: For more details, refer to  COMMENT . Yogesh Shinde LinkedInProfile <<< Back   Next >>>   
Read more

Snowflake Key Concepts

Image
  Snowflake is a cloud-based data warehouse that offers scalable and secure storage and processing of structured and semi-structured data. Snowflake uses a shared-nothing architecture for parallel processing and offers native support for SQL as well as other programming languages such as Python, R, and Java   Snowflake’s unique architecture consists of three key layers: -           Database Storage -           Query Processing -           Cloud Services In Snowflake, they have done the decoupling of storage and compute.   Virtual Warehouse: -           A compute resource in Snowflake that processes queries and performs data loading and unloading. -           It can be independently scaled up or down based on demand. -   ...
Read more