SELECT @num:=4000/USEMUN
FROM bom
WHERE CHILD_ITEM_NO =141;
SELECT PARENT_ITEM_NO,
CHILD_ITEM_NO,
FORMAT(USEAGE*@num,2),
USEmun
FROM bom
WHERE PARENT_ITEM_NO IN
(SELECT PARENT_ITEM_NO
FROM bom
WHERE PARENT_ITEM_NO LIKE '14%')
AND RIGHT(PARENT_ITEM_NO,1)=1
SQL定义变量和格式化
最新推荐文章于 2024-05-10 14:50:38 发布