select * from a
where not exists (select 'x' from b
where goods = a.goods
and type = 1
and operate_date > add_month(sysdate,-3));
where not exists (select 'x' from b
where goods = a.goods
and type = 1
and operate_date > add_month(sysdate,-3));
解决方案 »
- orcale 10g 的问题,急急急急
- Oracle中字符串与变量传值
- VB.net连接oracle,要求不用客户端不写注册表怎么做
- 触发器的应用问题
- Oracle 10g express能否生成带用insert语句插入全部数据的SQL脚本? (generate DDL)
- 数据库把时间字段存成vchar类型,该怎么比较时间呢
- 求助:关于oracle数据排序的问题.
- NEW PLAYER!
- 我要配置oralce的snmp服务
- 为什么数据库再用resetlogs打开数据库后要急着备份呢
- ===大型ERP系统,如SAP,在报表开发中,是否需要学习PLSQL程序设计?===
- 在sql plus下能提取oracle的所有数据表吗?
(select distinct goods from b where operate_date between 时间1 and
时间2 and type=1)
select goods from a where goods not in
(select distinct goods from b where operate_date between 时间1 and
时间2 and type=1)
select goods_a from (
select a.goods goods_a,bb.goods goods_b from a,
(select goods from b where operate_date between 时间1 and 时间2 and type=1) bb
where a.goods = bb.goods(+)
)
where goods_b is null;
minus
select goods from b where operate_date between 时间1 and 时间2 and type=1