Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
53942 Points
8147 Posts
Jul 21, 2010 08:28 AM|LINK
I think it will take some time to compare as its a row by row comparison.
I'm not sure if there is any optimised way to do.
If you are using Oracle, you can easily do minus query
SELECT A,B FROM DUAL
MINUS
SELECT C,D FROM DUAL
I'll check if there is any other better method to do this
sansan
All-Star
53942 Points
8147 Posts
Re: get the unmatched records from DataTable1 by comparing DataTable2
Jul 21, 2010 08:28 AM|LINK
I think it will take some time to compare as its a row by row comparison.
I'm not sure if there is any optimised way to do.
If you are using Oracle, you can easily do minus query
SELECT A,B FROM DUAL
MINUS
SELECT C,D FROM DUAL
I'll check if there is any other better method to do this