本文介绍了一种复杂的SQL查询技巧，通过使用SELECT语句从特定的数据表中筛选出符合多个条件的数据项。具体包括如何设置查询条件、排除某些匹配项、指定父级代码以及对结果进行排序等关键步骤。
SELECT *
FROM DIC_ITEM
WHERE DIC_CODE = 'FS990001'
AND NOT EXISTS (select * from organization_area o where o.area_code = item_code)
AND PARENT_CODE = '320581405000'
AND length(item_code) = 12
AND substr(item_code, -3, 3) <> '000'
ORDER BY ITEM_CODE
FROM DIC_ITEM
WHERE DIC_CODE = 'FS990001'
AND NOT EXISTS (select * from organization_area o where o.area_code = item_code)
AND PARENT_CODE = '320581405000'
AND length(item_code) = 12
AND substr(item_code, -3, 3) <> '000'
ORDER BY ITEM_CODE
扫一扫
896
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
