Tech-Discussion

         Derived Column Sometimes, you use two columns to derive values from them, and you need to filter the data based on this derived value. MS-SQL Server   We can achieve this by an additional level of SELECT as below: However, Snowflake allows you to use a derived column in the WHERE clause as below: Yogesh Shinde LinkedInProfile <<< Back   Next >>>   

        Data Type in Grid You regularly run a query and the result comes in the grid below. Sometimes you need to know the datatype of any column. MS-SQL Server   The grid which shows the data can't display the data type of that column. You have to go back to the table structure to see the data type of that column. However, the  Snowflake  grid shows datatype in symbolic ways as below: Yogesh Shinde LinkedInProfile <<< Back   Next >>>   

       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 . Yogesh Shinde LinkedInProfile <<< Back   Next >>>