「未來庫存」:修訂間差異
跳至導覽
跳至搜尋
無編輯摘要 |
|||
| 第3行: | 第3行: | ||
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>