17,086
社区成员
发帖
与我相关
我的任务
分享请帮忙看看我的sql 语句合理不合理？
需求：查询数据表TB_ZH_MONTH_BACK里本月有帐户号而上月无对应帐户号的数据
select NY||ZHH from TB_ZH_MONTH_BACKUP where NY = '当月' and not Exists (select * from TB_ZH_MONTH_BACKUP where NY = '前月')
select NY||ZHH from TB_ZH_MONTH_BACKUP where NY = '当月' and not Exists (select * from TB_ZH_MONTH_BACKUP where NY = '前月')
...全文
请发表友善的回复…
发表回复
zzwind5 2006-03-01
- 打赏
- 举报
select t1.NY||t1.ZHH from TB_ZH_MONTH_BACKUP t1, TB_ZH_MONTH_BACKUP t2
where t1.NY = '当月' and t2.NY = '前月' and t1.ZHH=t2.ZHH(+) and t2.ZHH is null
where t1.NY = '当月' and t2.NY = '前月' and t1.ZHH=t2.ZHH(+) and t2.ZHH is null
xiaoxiao1984 2006-02-28
- 打赏
- 举报
select a.NY||ZHH from TB_ZH_MONTH_BACKUP a where a.NY = '当月' and not Exists (select 1 from TB_ZH_MONTH_BACKUP b where b.NY = '前月' and a.帐户号 = b.帐户号)
boydgmx 2006-02-28
- 打赏
- 举报
select A.NY||A.ZHH
from TB_ZH_MONTH_BACKUP A
where A.NY = '当月'
and not Exists (
select *
from TB_ZH_MONTH_BACKUP B
where B.NY = '前月'
AND A.ZHH=B.ZHH
);
from TB_ZH_MONTH_BACKUP A
where A.NY = '当月'
and not Exists (
select *
from TB_ZH_MONTH_BACKUP B
where B.NY = '前月'
AND A.ZHH=B.ZHH
);
gaolin 2006-02-28
- 打赏
- 举报
自己顶！
