電線加工品最近缺線日
<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>