Thread: How can I selet rows which have 2 columns values cross equal?
View Single Post
  #4 (permalink)  
Old 05-24-2006, 12:34 AM
vinay kumar
 
Posts: n/a
Default Oracle answer. Re: How can I selet rows which have 2 columns values cross equal?
[sql]
SELECT DISTINCT x.Id
FROM test x
, test y
WHERE x.Id<> y.Id
AND (x.a+x.b)=(y.a+y.b)
[/sql]
Reply With Quote