2025年4月27日
记录根据BOM子节点反查BOM根节点的一段SQL
摘要： WITH BOM_TREE AS (SELECT PECODE, CONNECT_BY_ISLEAF AS IS_LEAF, CONNECT_BY_ROOT(LID) AS LID FROM PSEBOMLINE START WITH 1=1 AND CHANGEDODDNUM='[CHANGEDO 阅读全文
posted @ 2025-04-27 11:45 吖吼、 阅读(27) 评论(0) 推荐(0)