[thelist] SQL Challenge Question

Anthony Baratta Anthony at Baratta.com
Mon Oct 27 19:47:57 CST 2003

At 02:32 PM 10/27/2003, Rob Smith wrote:
>I've got an SQL Challenge for you.
>         Given: Two nearly Identical Rows
>         Problem: Isolate the columns where the data
>                    is not the same.
>         Solution: ?

If you are only interested in check each row itself:

select * from table where col1 <> col2.

if you want to find those values in all of col1 not in col2

select * from table where col1 not in (select col2 from table)

reverse for other way

select * from table where col2 not in (select col1 from table)

there are other ways by joining the table to itself.

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list