ask for help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ask for help

ask for help# Database - 数据库

d*r2007-10-03 07:10

1 楼

One table has "origin", "dest", "date", "type",
actually one the same day, from origin to destination there are type 1,2,
and 4.
I would like to pick up those records that on that day, on that route,
only type 4 happens. I want to just use one query to implement it.
Please advise me, thanks.

m*y2007-10-03 07:10

2 楼

SELECT *
FROM
WHERE date=
AND origin=
AND dest=
AND type=4

j*w2007-10-03 07:10

3 楼

你这个不保证那天只有4阿

【在 m******y 的大作中提到】

: SELECT *
: FROM
: WHERE date=
: AND origin=
: AND dest=
: AND type=4

t*g2007-10-03 07:10

4 楼

oracle?
select date, origin, dest from table where type = 4 group by date, orgin,
dest
minus
select date, origin, dest from table where type <> 4 group by date, orgin,
dest

【在 d******r 的大作中提到】

: One table has "origin", "dest", "date", "type",
: actually one the same day, from origin to destination there are type 1,2,
: and 4.
: I would like to pick up those records that on that day, on that route,
: only type 4 happens. I want to just use one query to implement it.
: Please advise me, thanks.

j*w2007-10-03 07:10

5 楼

select * from table_name a where
not exist (select * from table_name b where type in (1,2) and
a.origin=b.origin and a.dest = b.dest and a.date=b.date)

【在 d******r 的大作中提到】