Learn Quick, Lead Quicker
In SQL, an INNER JOIN is utilized to merge rows from two or more tables based on a shared column. It only delivers the data from the intersection of the tables or the rows for which the stated condition is true. Here’s the basic syntax for using INNER JOIN in SQL:
We all know that SELECT * FROM table_name gives us all the columns from table but sometimes we need to select all the columns except a few columns. One of the easiest ways is to manually specify columns and exclude unwanted columns, like:
SELECT column_1,column_2, column_3,…column_n FROM table_name;
Snowflake has one cool function called HASH_AGG which returns a 64 bit signed hash value over the set of inputs column. As the snowflake document itself mentioned, “HASH_AGG is not a cryptographic hash function and should not be used as such”. We can use it to compare whether two columns or sets of columns value are identical or not.