I should have made my question more clear. Actually what I wanted to do is a query like


select a.column02 from TEST a, TEST b where a.column02 != b.column02 and a.column03 = a.column03



i just realized that it is not that complicated as i thought since the value of column03 is has to be distinct, but thanks anyway.