CODEWITHSUNDEEP
phpmysql
Param Kumar
Param Kumar

Reputation: 123

compare rows of two query set result in same table

I have table where I store data on basis of date.

Now I need to check that: is there any difference between data of rows with two different dates.

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 -

SELECT *  FROM `national` WHERE `upload_date` = '2015-08-04'  // return 106 rows

and 

SELECT *  FROM `national` WHERE `upload_date` = '2015-08-01'   // return 106 rows

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.

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

Can Any one please provide me correct query ?? thank you

Upvotes: 2

Views: 1740

Answers (2)

smali
smali

Reputation: 4805

Try this 

 (
  SELECT t1.* 
  FROM 
     `national` t1, `national` t2 
  where
      t1.upload_date = '2015-08-01' and t2.upload_date='2015-08-04' and
      -- put your columns here that you want to compare for same DATA
      -- like t1.name=t2.name and etc...
 )

Upvotes: 2

Blaztix
Blaztix

Reputation: 1294

You can try with something like that

SELECT * FROM (SELECT * FROM `national` WHERE upload_date = '2015-08-01') a
INNER JOIN (SELECT * FROM `national` WHERE upload_date = '2015-08-04') b
     ON a.emp_id = b.emp_id AND a.uqi_id = b.uqi_id
ORDER BY uqi_id

Upvotes: 0

Related Questions