Re: DIFF
From: John Dorlon <john_at_ezsql.net>
Date: 19 Jul 2001 13:42:36 -0700
Message-ID: <a8097a33.0107191242.13da2028_at_posting.google.com>
Date: 19 Jul 2001 13:42:36 -0700
Message-ID: <a8097a33.0107191242.13da2028_at_posting.google.com>
Select * from table1
minus
select * from table2
run the query. No rows means same data. It will catch all but rows that exist in table 2 but not in table1. To get those, do
select * from table2
minus
select * from table1
-John
www.ezsql.net
"Bigfoot" <ext6axp_at_ups.com> wrote in message news:<9j6sac$1pp2_at_biko.telecom.ups.com>...
> I have two tables and I need to get the difference between them.
> Each table has around 9 million rows. What is best way.
>
> Thanks
> Pushparaj
Received on Thu Jul 19 2001 - 22:42:36 CEST