未來庫存

出自TSK WIKI
跳至導覽 跳至搜尋

電線加工品最近缺線日

<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>