s****s
发帖数: 42 | 1 List the car dealers who have owned all the car models which have been owned
by Jone dealeaship in Oracle?
dealer model |
t*******y
发帖数: 57 | 2 这个比较难了?
谁设计的这么恶心的数据库?都多对多了,还能体现关系型数据库的优势吗?
【在 s****s 的大作中提到】
: List the car dealers who have owned all the car models which have been owned
: by Jone dealeaship in Oracle?
: dealer model
|
g*****g
发帖数: 34805 | 3 typical exam question
【在 t*******y 的大作中提到】
: 这个比较难了?
: 谁设计的这么恶心的数据库?都多对多了,还能体现关系型数据库的优势吗?
|
s***e
发帖数: 284 | 4 nod
must be homework or exam in previous years
【在 g*****g 的大作中提到】
: typical exam question
|
s*****n
发帖数: 29 | 5 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
|
