title: compare rows of two query set result in same table
body: <p>I have table where I store data on basis of date. </p>
  
  <p>Now I need to check that: is there any difference between data of rows with two different dates. </p>
  
  <p>In a simple way you can say that I have two queries which select data from same table now I have to compare each row and column value. for example my two query are -</p>
  
  <pre><code>SELECT *  FROM `national` WHERE `upload_date` = '2015-08-04'  // return 106 rows
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT *  FROM `national` WHERE `upload_date` = '2015-08-01'   // return 106 rows
  </code></pre>
  
  <p>I have tried to compare this with below query but the result not seem to be correct to me, I am not satisfy with this.</p>
  
  <pre><code>Select U.* from 
  (SELECT t1.* FROM `national` t1 where upload_date = '2015-08-01'
  union all
  SELECT t2.*  FROM `national` t2 WHERE `upload_date` = '2015-08-04' ) U
  GROUP BY emp_id, uqi_id
  HAVING COUNT(*) = 1
  </code></pre>
  
  <p>Can Any one please provide me correct query ?? thank you</p>