锘??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>&#20122;&#27954;&#27431;&#27954;&#22312;&#32447;&#35270;&#39057;&#44;&#57;&#49;&#31934;&#21697;&#35270;&#39057;&#20813;&#36153;&#44;&#54;&#57;&#35270;&#39057;&#22312;&#32447;</title><link>http://www.aygfsteel.com/hzjun/</link><description /><language>zh-cn</language><lastBuildDate>Fri, 20 Jun 2025 00:07:37 GMT</lastBuildDate><pubDate>Fri, 20 Jun 2025 00:07:37 GMT</pubDate><ttl>60</ttl><item><title>oracle lead over</title><link>http://www.aygfsteel.com/hzjun/archive/2010/01/30/311330.html</link><dc:creator>鑳＄珷淇?/dc:creator><author>鑳＄珷淇?/author><pubDate>Sat, 30 Jan 2010 08:18:00 GMT</pubDate><guid>http://www.aygfsteel.com/hzjun/archive/2010/01/30/311330.html</guid><wfw:comment>http://www.aygfsteel.com/hzjun/comments/311330.html</wfw:comment><comments>http://www.aygfsteel.com/hzjun/archive/2010/01/30/311330.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/hzjun/comments/commentRss/311330.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/hzjun/services/trackbacks/311330.html</trackback:ping><description><![CDATA[<p>濡俵ogin琛ㄦ湁浜哄憳ID鐧婚檰鎴栫櫥鍑烘椂闂磘ime姹傛瘡澶╂瘡嬈＄櫥闄嗙櫥鍑轟竴嬈＄殑鍦ㄧ嚎鏃墮棿錛?br />
&nbsp; </p>
<p>select login.id as浜哄憳ID&nbsp;,login.status as 鐧婚檰鐧誨嚭鐘舵�?br />
&nbsp;login.time as 鐧婚檰鎴栫櫥鍑烘椂闂?nbsp;, <br />
lead(login.time) over (partition by login.id,trunc(login.time) order by login.time)&nbsp; as 涓嬫鐧誨嚭鎴栫櫥鍑烘椂闂?/p>
<p>from login login</p>
榪欐牱鐘舵�佹槸鐧婚檰鐨勮褰曞氨浼氬悓鏃舵嫢鏈夌櫥鍑虹殑鏃墮棿錛岃繖鏍蜂袱鑰呬竴鍑忓氨鏄湪綰挎椂闂翠簡銆?br />
lead鍑芥暟鏄彇涓嬩竴鏉¤褰曪紝over (partition by login.id,trunc(login.time))濡傚悓瀵筰d,time鍒嗙粍錛?br />
order by login.time鏄寜鏃墮棿鎺掑簭錛岃繖鏍峰彲浠ョ煡閬撴槸鐧婚檰鐧誨嚭鐨勯『瀵?
<img src ="http://www.aygfsteel.com/hzjun/aggbug/311330.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/hzjun/" target="_blank">鑳＄珷淇?/a> 2010-01-30 16:18 <a href="http://www.aygfsteel.com/hzjun/archive/2010/01/30/311330.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鎶ュ埌</title><link>http://www.aygfsteel.com/hzjun/archive/2009/08/14/291134.html</link><dc:creator>鑳＄珷淇?/dc:creator><author>鑳＄珷淇?/author><pubDate>Fri, 14 Aug 2009 03:46:00 GMT</pubDate><guid>http://www.aygfsteel.com/hzjun/archive/2009/08/14/291134.html</guid><wfw:comment>http://www.aygfsteel.com/hzjun/comments/291134.html</wfw:comment><comments>http://www.aygfsteel.com/hzjun/archive/2009/08/14/291134.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/hzjun/comments/commentRss/291134.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/hzjun/services/trackbacks/291134.html</trackback:ping><description><![CDATA[鏂頒漢鎶ュ埌<br />
<img src ="http://www.aygfsteel.com/hzjun/aggbug/291134.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/hzjun/" target="_blank">鑳＄珷淇?/a> 2009-08-14 11:46 <a href="http://www.aygfsteel.com/hzjun/archive/2009/08/14/291134.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>