「未來庫存」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==電線加工品最近缺線日== *<SQL> SELECT * FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) as rown, * FROM v_PRCABLEDAILY WHERE VSUMTD008<0 AND VTD004 N... |
無編輯摘要 |
||
| 第1行: | 第1行: | ||
==電線加工品最近缺線日== | ==電線加工品最近缺線日== | ||
*<SQL> | * | ||
<SQL> | |||
SELECT * | SELECT * | ||
FROM ( | FROM ( | ||
於 2018年6月29日 (五) 20:07 的修訂
電線加工品最近缺線日
<SQL> SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) as rown, * FROM v_PRCABLEDAILY WHERE VSUMTD008<0 AND VTD004 NOT LIKE '6%') AS T1
WHERE rown = 1 ORDER BY VTD013 </SQL>