title: SQL - Snowflake Minus Operator
body: <p>Hi I am running a query to check for any changes in a table between two dates....</p>
  <pre><code>SELECT * FROM TABLE_A where run_time = current_date() 
  MINUS
  SELECT * FROM TABLE_A where run_time = current_date()-1 
  </code></pre>
  <p>The first select statement (where run_time = current_date() return 3,357,210 records.
  The second select statement (where run_time = current_date()-1 returns 0 records.</p>
  <p>Using the MINUS operator, I was expecting to see 3,357,210 records (3,357,210 - 0) but instead I get 2,026,434</p>
  <p>Any thoughts on why? Thanks</p>