「未來庫存」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==電線加工品最近缺線日== *<SQL> SELECT * FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) as rown, * FROM v_PRCABLEDAILY WHERE VSUMTD008<0 AND VTD004 N... |
無編輯摘要 |
||
| (未顯示同一使用者於中間所作的 2 次修訂) | |||
| 第1行: | 第1行: | ||
==電線加工品最近缺線日== | ==電線加工品最近缺線日== | ||
<SQL> | |||
SELECT * | SELECT * | ||
FROM ( | FROM ( | ||
SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) | 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 | FROM v_PRCABLEDAILY WHERE VSUMTD008<0 AND VTD004 NOT LIKE '6%' | ||
AND VTD013>= CONVERT(VARCHAR,GETDATE(),112) ) AS T1 | |||
WHERE rown = 1 ORDER BY VTD013 | WHERE rown = 1 ORDER BY VTD013 | ||
</SQL> | </SQL> | ||
於 2018年6月29日 (五) 20:32 的最新修訂
電線加工品最近缺線日
<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%'
AND VTD013>= CONVERT(VARCHAR,GETDATE(),112) ) AS T1 WHERE rown = 1 ORDER BY VTD013 </SQL>