「未來庫存」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
無編輯摘要
Root​(留言 | 貢獻)
無編輯摘要
 
(未顯示同一使用者於中間所作的 1 次修訂)
第1行: 第1行:
==電線加工品最近缺線日==
==電線加工品最近缺線日==
*
<SQL>
<SQL>
SELECT *
SELECT *
FROM (
FROM (
  SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) as rown,
  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>