锘??xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>&#22269;&#20135;&#20061;&#20061;&#35270;&#39057;&#19968;&#21306;&#20108;&#21306;&#19977;&#21306;&#44;&#20037;&#20037;&#22269;&#20135;&#31934;&#21697;&#57;&#57;&#31934;&#21697;&#22269;&#20135;&#13;&#44;&#22312;&#32447;&#35266;&#30475;&#20122;&#27954;</title><link>http://www.aygfsteel.com/yakihappy/archive/2009/12/02/304494.html</link><dc:creator>嫻烽槼楦?/dc:creator><author>嫻烽槼楦?/author><pubDate>Wed, 02 Dec 2009 03:50:00 GMT</pubDate><guid>http://www.aygfsteel.com/yakihappy/archive/2009/12/02/304494.html</guid><wfw:comment>http://www.aygfsteel.com/yakihappy/comments/304494.html</wfw:comment><comments>http://www.aygfsteel.com/yakihappy/archive/2009/12/02/304494.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/yakihappy/comments/commentRss/304494.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/yakihappy/services/trackbacks/304494.html</trackback:ping><description><![CDATA[<p><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>鏉′歡</span></span></span></span></span><font style="background-color: #c7edcc"><br />
<span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>TableName: material</span></span></span></span></span></font></p>
<p><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>Field Name : serial_number,group_name,lot_id</span></span></span></span></span></p>
<p><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>Date Example:<br />
1&nbsp;&nbsp;&nbsp; 10001,&nbsp; MB_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000001<br />
2&nbsp;&nbsp;&nbsp; 10001,&nbsp; TVE_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TVEID000001<br />
3&nbsp;&nbsp;&nbsp; 10001,&nbsp; MODEM_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MODEMID000001<br />
4&nbsp;&nbsp;&nbsp; 10002,&nbsp; MB_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000002<br />
5&nbsp;&nbsp;&nbsp; 10002,&nbsp; TVE_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TVEID000002<br />
6&nbsp;&nbsp;&nbsp; 10002,&nbsp; MODEM_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MODEMID000002<br />
7&nbsp;&nbsp;&nbsp; 10003,&nbsp; MB_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000003<br />
8&nbsp;&nbsp;&nbsp; 10003,&nbsp; TVE_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TVEID000003<br />
9&nbsp;&nbsp;&nbsp; 10003,&nbsp; MODEM_MD,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MODEMID000003<br />
==========================================<br />
SQL:<br />
select&nbsp; serial_number ,max(decode(group_name,'MB_MD',lot_id,'')) MB_MD,</span></span></span></span></span><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span><font style="background-color: #c7edcc"> max(decode(group_name,'TVE_MD',lot_id,'')) TVE_MD,<br />
</font><font style="background-color: #c7edcc">max(decode(group_name,'MODEM_MD',lot_id,'')) MODEM_MD&nbsp;&nbsp; </font><font style="background-color: #c7edcc">from material&nbsp;&nbsp; </font></span></span></span></span></span><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>group by serial_number<br />
==========================================<br />
緇撴灉:<br />
serial_number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MB_MD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TVE_MD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MODEM_MD<br />
10001,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000001,&nbsp;&nbsp; TVEID000001,&nbsp; MODEMID000001<br />
10002,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000002,&nbsp;&nbsp; TVEID000002,&nbsp; MODEMID000002<br />
10003,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MBID000003,&nbsp;&nbsp; TVEID000003,&nbsp; MODEMID000003</span></span></span></span></span></p>
<p><font style="background-color: #c7edcc"></font><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>&nbsp;</span></span></span></span></span></p>
<p><span style="font-family: 瀹嬩綋"><span style="font-family: Times New Roman"><span style="font-size: 14pt"><span style="font-size: 12pt"><span>鏈枃鏉ヨ嚜CSDN鍗氬錛岃漿杞借鏍囨槑鍑哄錛歨ttp://blog.csdn.net/Bogues/archive/2004/10/26/152708.aspx</span></span></span></span></span></p>
<img src ="http://www.aygfsteel.com/yakihappy/aggbug/304494.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/yakihappy/" target="_blank">嫻烽槼楦?/a> 2009-12-02 11:50 <a href="http://www.aygfsteel.com/yakihappy/archive/2009/12/02/304494.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss>      <footer>
<div class="friendship-link">
<a href="http://www.aygfsteel.com/" title="&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;">&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;</a>

</div>

</footer>


主站蜘蛛池模板：
<a href="http://" target="_blank">福鼎市</a>|
<a href="http://" target="_blank">双流县</a>|
<a href="http://" target="_blank">内江市</a>|
<a href="http://" target="_blank">和平区</a>|
<a href="http://" target="_blank">旬邑县</a>|
<a href="http://" target="_blank">巫溪县</a>|
<a href="http://" target="_blank">永登县</a>|
<a href="http://" target="_blank">利辛县</a>|
<a href="http://" target="_blank">宣威市</a>|
<a href="http://" target="_blank">察隅县</a>|
<a href="http://" target="_blank">彰武县</a>|
<a href="http://" target="_blank">常山县</a>|
<a href="http://" target="_blank">万州区</a>|
<a href="http://" target="_blank">监利县</a>|
<a href="http://" target="_blank">浠水县</a>|
<a href="http://" target="_blank">遂川县</a>|
<a href="http://" target="_blank">扶余县</a>|
<a href="http://" target="_blank">梁山县</a>|
<a href="http://" target="_blank">樟树市</a>|
<a href="http://" target="_blank">保德县</a>|
<a href="http://" target="_blank">连南</a>|
<a href="http://" target="_blank">江孜县</a>|
<a href="http://" target="_blank">武穴市</a>|
<a href="http://" target="_blank">介休市</a>|
<a href="http://" target="_blank">贺兰县</a>|
<a href="http://" target="_blank">乐昌市</a>|
<a href="http://" target="_blank">和顺县</a>|
<a href="http://" target="_blank">勐海县</a>|
<a href="http://" target="_blank">鄂托克旗</a>|
<a href="http://" target="_blank">手游</a>|
<a href="http://" target="_blank">洛隆县</a>|
<a href="http://" target="_blank">平谷区</a>|
<a href="http://" target="_blank">富裕县</a>|
<a href="http://" target="_blank">湖北省</a>|
<a href="http://" target="_blank">磐石市</a>|
<a href="http://" target="_blank">穆棱市</a>|
<a href="http://" target="_blank">邵阳市</a>|
<a href="http://" target="_blank">舟曲县</a>|
<a href="http://" target="_blank">温泉县</a>|
<a href="http://" target="_blank">定日县</a>|
<a href="http://" target="_blank">伊吾县</a>|
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>