If the dealer/model pair is unique try this select * from (select t2.dealer from t t1 join t t2 on (t1.model = t2.model) where t1.dealer='Jone') group by dealer having count(*) >= (select count(*) from t where dealer = 'Jone'); Of course Jone is also selected.
【在 s****s 的大作中提到】 : List the car dealers who have owned all the car models which have been owned : by Jone dealeaship in Oracle? : dealer model