How to make this query?# Database - 数据库
s*s
1 楼
List the car dealers who have owned all the car models which have been owned
by Jone dealeaship in Oracle?
dealer model
by Jone dealeaship in Oracle?
dealer model
t*y
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
谁设计的这么恶心的数据库?都多对多了,还能体现关系型数据库的优势吗?
【在 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
3 楼
typical exam question
【在 t*******y 的大作中提到】
: 这个比较难了?
: 谁设计的这么恶心的数据库?都多对多了,还能体现关系型数据库的优势吗?
【在 t*******y 的大作中提到】
: 这个比较难了?
: 谁设计的这么恶心的数据库?都多对多了,还能体现关系型数据库的优势吗?
s*e
4 楼
nod
must be homework or exam in previous years
【在 g*****g 的大作中提到】
: typical exam question
must be homework or exam in previous years
【在 g*****g 的大作中提到】
: typical exam question
s*n
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
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
相关阅读
DB2之反击(ZZ)怎么查找出所有类似的产品？请教如何在两个Oracle之间倒数据Which replication to use?PHP 代码 下载数据大家推荐几个data warehouse的解决方案吧programing的contract job每天都要按时去公司上班吗？早9晚5？T-SQL 问题为什么微软专家给一个4x5的只读小表建64个Index(完全相同的)?linked SQL Server in 2005小网站项目行情交流为什么我不能Access linked server object请教高手：想考Oracle的data warehouse认证，不知有没有价值关于MSSQL, 问几个比较土的问题能不能推荐一本关于数据库原理和应用的书？发一个在BWI附近的dba 工作问个问题： Can't connect to MySQL server on 'dbhost' (10061) ( 2003 )在SQL 2005 reporting service里，怎样设置security啊？toad9.6.1.1里面有咋不显示光标位置了呢oracle菜鸟问题。