select * from table1 where any_column='something'
minus
select * from table1 where any_column='something_else';

:-)

-----Mensaje original-----
De: Khaled Harb [mailto:[Email Address Removed]
Enviado el: jue 16/10/2003 12:06
Para: LazyDBA.com Discussion
CC:
Asunto: Need to compare two rows in a table



Hi dba'S

I want to compare 2 rows value in a table and report the difference

How can I do this?
Regards


--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed]
To subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page