<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E5%A4%A7%E5%90%8C%E6%96%99%E8%99%9F%E8%AE%8A%E6%9B%B4</id>
	<title>大同料號變更 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E5%A4%A7%E5%90%8C%E6%96%99%E8%99%9F%E8%AE%8A%E6%9B%B4"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%A4%A7%E5%90%8C%E6%96%99%E8%99%9F%E8%AE%8A%E6%9B%B4&amp;action=history"/>
	<updated>2026-11-16T22:11:36Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E5%A4%A7%E5%90%8C%E6%96%99%E8%99%9F%E8%AE%8A%E6%9B%B4&amp;diff=2570&amp;oldid=prev</id>
		<title>Root：​新頁面: ==程式碼== &lt;sql&gt; SELECT  A1,A2,B2,MB003 FROM  (SELECT RTRIM(A1) AS A1,A2,B2 FROM  (SELECT TD004 AS A1,TD005 AS A2 FROM  (SELECT TD004,TD005, row_number()over(partition by TD004 ORDE...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%A4%A7%E5%90%8C%E6%96%99%E8%99%9F%E8%AE%8A%E6%9B%B4&amp;diff=2570&amp;oldid=prev"/>
		<updated>2016-12-20T02:00:14Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==程式碼== &amp;lt;sql&amp;gt; SELECT  A1,A2,B2,MB003 FROM  (SELECT RTRIM(A1) AS A1,A2,B2 FROM  (SELECT TD004 AS A1,TD005 AS A2 FROM  (SELECT TD004,TD005, row_number()over(partition by TD004 ORDE...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==程式碼==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT  A1,A2,B2,MB003 FROM &lt;br /&gt;
(SELECT RTRIM(A1) AS A1,A2,B2 FROM &lt;br /&gt;
(SELECT TD004 AS A1,TD005 AS A2 FROM &lt;br /&gt;
(SELECT TD004,TD005, row_number()over(partition by TD004 ORDER BY TD002 DESC ) AS NUM FROM COPTD&lt;br /&gt;
WHERE TD021=&amp;#039;Y&amp;#039; AND TD005 LIKE &amp;#039;0197-%&amp;#039; AND TD005 NOT LIKE &amp;#039;0197-U%&amp;#039;)X1&lt;br /&gt;
WHERE NUM=&amp;#039;1&amp;#039; GROUP BY TD004,TD005)X&lt;br /&gt;
JOIN&lt;br /&gt;
(SELECT TD004 AS B1,TD005 AS B2 FROM COPTD WHERE TD021=&amp;#039;Y&amp;#039; AND TD005  LIKE &amp;#039;0197-U%&amp;#039; GROUP BY TD004,TD005) Y&lt;br /&gt;
ON A1=B1)Z&lt;br /&gt;
JOIN INVMB ON MB001=A1&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>