Re: Similar Rows...

Florent,

You can do this in SQL with :

SELECT *
FROM mytable tab1
WHERE EXISTS( SELECT *

              FROM   mytable tab2
              WHERE  tab2.code = tab1.code
              AND    tab2.name != tab1.name )

Note: This would not pick up rows where the code column was NULL.

Regards
Steve Blomeley Received on Thu Nov 02 2000 - 17:15:08 CST