17,377
社区成员
发帖
与我相关
我的任务
分享
select *
from IFSAPP.SHOP_ORD
where DATE_ENTERED>=DATE'2019-11-1'
AND DATE_ENTERED<= DATE '2019-11-30'
AND CONTRACT='PPCD'
select *
from IFSAPP.SHOP_ORD
where DATE_ENTERED>=DATE'2019-11-1'
AND DATE_ENTERED<= DATE '2019-11-30'
AND CONTRACT='PPCD'
AND PART_NO NOT IN (SELECT PART_NO FROM IFSAPP.SHOP_ORD WHERE PART_NO LIKE'45%'OR PART_NO LIKE '50%')
select *
from IFSAPP.SHOP_ORD
where DATE_ENTERED >= DATE '2019-11-1'
AND DATE_ENTERED <= DATE '2019-11-30'
AND CONTRACT = 'PPCD'
and instr(PART_NO, '45') != 1
and instr(PART_NO, '50') != 1