暫存SQL碼

出自TSK WIKI
於 2016年5月14日 (六) 10:28 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==領料單列印== *20160514 以PDO取值 <sql> SELECT DENSE_RANK() OVER (ORDER BY TE002) AS ROWID ,X.*,TB004,CAST(TB004/TA015 AS FLOAT) AS EACHQ FROM (SELECT TA001,TA002,TD005,TE001...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

領料單列印

  • 20160514 以PDO取值

<sql> SELECT DENSE_RANK() OVER (ORDER BY TE002) AS ROWID ,X.*,TB004,CAST(TB004/TA015 AS FLOAT) AS EACHQ FROM (SELECT TA001,TA002,TD005,TE001,TE002,TE003,TE004,TE017,TA015,TE005,TD013,TA520,TA526, TC004,TE019,TA011,TA013,TE010,TE011,TE012,TC075 AS MA002 FROM MOCTA JOIN MOCTE ON TA001=TE011 AND TA002=TE012 JOIN INVMB ON MB001=TE004 JOIN v_COPTCD ON TA001='5102' AND TA002=TD054 WHERE TE001= '5403' AND MB007<>'302' AND TA001='5102' AND TA002 LIKE '%150811006%')X JOIN MOCTB ON TB001=TE011 AND TB002=TE012 AND TB003=TE004 WHERE TE019<>'V' ORDER BY TE004 </SQL>