17,086
社区成员
发帖
与我相关
我的任务
分享
with t1 as
(select '粉状减水剂' as "原材料", '粉状' as"关键字" FROM DUAL
union all
select '粉状粘合剂','粘合剂' FROM DUAL
UNION ALL
SELECT '粉状增合剂','石膏'FROM DUAL
UNION ALL
SELECT '氨基磺酸',NULL FROM DUAL
UNION ALL
SELECT '葡萄糖酸钠',NULL FROM DUAL
UNION ALL
SELECT '白砂糖',NULL FROM DUAL
UNION ALL
SELECT '木钙',NULL FROM DUAL
UNION ALL
SELECT '氟石膏粉',NULL FROM DUAL)
SELECT T1."原材料" FROM T1 WHERE NOT EXISTS(
SELECT 1 FROM(
SELECT DISTINCT T1."原材料" FROM T1 , (SELECT "关键字" FROM T1 ) B
WHERE instr(T1."原材料" , B."关键字")>0)P
WHERE P."原材料" =T1."原材料" )
/*
原材料
1 氨基磺酸
2 葡萄糖酸钠
3 白砂糖
4 木钙
*/
写法不简便,待优化