Tech-Discussion

Row Comparison - HASH When we need to compare data across all columns in two particular tables. MS-SQL Server We can achieve it as follows: In Snowflake , we use HASH  as follows: For more details, refer to the HASH section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

  ORDER BY ALL - SORTING When we fetch data, we sometimes need to sort it. If there are limited columns, then it is fine. Suppose there are multiple columns, then you have to mention the entire list of columns in an order by clause, which is a tedious job. MS-SQL Server We can achieve it as follows: In  Snowflake ,    we can use a similar approach as above; however, we can make use of  ORDER BY ALL  as follows: For more details, refer to the  ORDER BY ALL  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series    

  Last Value Whenever we are sorting out the data and want to find the last value in the series. MS-SQL Server We can achieve it as follows: In  Snowflake ,    we can use a similar approach as above; however, we can make use of  LAST_VALUE  as follows: For more details, refer to the  LAST_VALUE  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series