SELECT A.PART_NO,A.QTY_REQUIRED,B.UNIT_MEAS,
A.QTY_REQUIRED*100/sum(A.QTY_REQUIRED) over(partition by B.UNIT_MEAS) percent
FROM IFSAPP.SHOP_MATERIAL_ALLOC A, IFSAPP.INVENTORY_PART B
WHERE A.order_no='1952380R'
AND A.PART_NO=B.part_no
AND B.contract='PPCD'
AND A.PART_NO NOT IN (3352965,3352967,3352968,3352969,3288350,3352966)
(3352965,3352967,3352968,3352969,3288350,3352966) --想通过模糊子查询(第一个数字为3),比如用like这样的字段,怎么实现?谢谢
A.QTY_REQUIRED*100/sum(A.QTY_REQUIRED) over(partition by B.UNIT_MEAS) percent
FROM IFSAPP.SHOP_MATERIAL_ALLOC A, IFSAPP.INVENTORY_PART B
WHERE A.order_no='1952380R'
AND A.PART_NO=B.part_no
AND B.contract='PPCD'
AND A.PART_NO NOT IN (3352965,3352967,3352968,3352969,3288350,3352966)
(3352965,3352967,3352968,3352969,3288350,3352966) --想通过模糊子查询(第一个数字为3),比如用like这样的字段,怎么实现?谢谢
解决方案 »
- 为什么我连oracle 11g的启动界面都看不到,就我遇到,不会吧
- oracle developer中调用返回游标的过程
- ora-00600错误
- 关于分区表的几个问题
- 请教,ORACLE中与TRIM相对的,将字符串搞成固定长度,不足填空格的语句
- 新手问个问题啊
- 如何猜测Listener经常停止的原因?
- 再问一个关于“TNS:监听程序不能解析在连接描述符给出的SERVICE_NAME”的问题!!
- 如何在sqlplus中插入多字段的纪录,详细请看内容
- 请问:SELECT MM_DEAL.CAN_REJ_DTE AS CANCEL_DTE, MM_DEAL.CAN_AUTH_DTE AS CANCEL_DTE, 为何不能用Order by CANCEL_DTE
- 虚拟机下Linux下安装Oacle11g rac 中出现第六步rac2节点找不到
- Oracle
FROM IFSAPP.SHOP_MATERIAL_ALLOC A
WHERE A.order_no='1952380R'
AND A.PART_NO like '3%'