i'm selecting group of records , want filter column in logic of xor - not null xor null.
--basic select make, model cars results -------- ford taurus ford (null) toyota camry toyota (null) honda (null) --obviously xor not real oracle operator --this i'm trying do.. select make, model cars model not null xor model null results (pulls records model not null, falling null if necessary) -------- ford taurus toyota camry honda (null)
can give me insight on how achieve desired result i'm looking for? i'm struggling on one!
many thanks!
select make, model ( select c.*, row_number() on (partition make order model nulls last) rn cars c ) not (rn > 1 , model null)
Comments
Post a Comment