{"id":73,"date":"2013-03-12T11:36:27","date_gmt":"2013-03-12T03:36:27","guid":{"rendered":"http:\/\/www.dongcb.com\/?p=73"},"modified":"2013-03-12T11:36:27","modified_gmt":"2013-03-12T03:36:27","slug":"row_number-over%e7%94%a8%e4%be%8b%e5%8f%8a%e7%9b%b8%e8%bf%91%e5%87%bd%e6%95%b0rank%e5%92%8cdense_rank%e7%9a%84%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/www.dongchangbin.net.cn\/?p=73","title":{"rendered":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd"},"content":{"rendered":"<p>\u4eca\u5929\u5728\u7fa4\u91cc\u8ddf\u4e00\u7fa4\u540c\u5b66\u804a\u5929\uff0c\u604d\u7136\u53d1\u73b0\u6709\u4e2a\u540c\u5b66\u6b63\u5728\u671ddba\u7684\u65b9\u5411\u53d1\u5c55\uff0c\u6b63\u597d\u8111\u5b50\u91cc\u6709\u4e2a\u4ee5\u524d\u7684\u95ee\u9898\u60f3\u8981\u95ee\u4e00\u4e0b\uff0c\u95ee\u9898\u662f\uff1arow_number() over()\u4f7f\u7528partition by\u7684\u65f6\u5019\uff0c\u540e\u9762\u6761\u4ef6\u7ea6\u675f\u4f7f\u7528\u4ec0\u4e48\u5173\u952e\u8bcd\u4f1a\u5bfc\u81f4\u524d\u9762\u7684partition by\u5931\u6548\u3002\u7ed3\u679c\u540c\u5b66\u4f1aorder by\uff0c\u4f46\u662f\u6728\u6709\u63a5\u89e6\u8fc7partition by\u3002\u3002\u3002<\/p>\n<p>\u65e9\u996d\u90fd\u5fd8\u4e86\u5403\u4e86\u3002\u3002<\/p>\n<p>\u8fd9\u662f\u4e2a\u95ee\u9898\u554a\uff0c\u867d\u7136\u90a3\u6b21\u5f00\u53d1\u7684\u65f6\u5019\u5199\u7684\u8bed\u53e5\u51fa\u73b0\u7684\u73b0\u8c61\u4e0d\u4e00\u5b9a\u5177\u6709\u5178\u578b\u610f\u4e49\uff0c\u4f46\u662f\u6211\u89c9\u5f97\u8fd9\u4e2a\u51fd\u6570\u7528\u8d77\u6765\u5f88\u8212\u670d\uff0c\u6709\u5f88\u591a\u8ba9\u6211\u4e2a\u4eba\u5f88\u6ee1\u610f\u7684\u529f\u80fd\uff0c\u4ee5\u540e\u8981\u7528\u5c31\u4e0d\u80fd\u4e0d\u5f04\u660e\u767d\u8fd9\u4e9b\u95ee\u9898\u3002\u540c\u5b66\u4e0d\u80fd\u89e3\u51b3\uff0c\u90a3\u5c31\u987a\u624b\u5728\u7f51\u4e0a\u627e\u4e00\u4e0b\u770b\u6709\u6ca1\u6709\u76f8\u5173\u7684\u6587\u6863\u80fd\u53c2\u8003\u4e00\u4e0b\u4e86\u3002<\/p>\n<p>\u767e\u5ea6\uff0c\u641c\u7d22\uff0c\u5173\u952e\u8bcd \u201crow_number partition by\u4ec0\u4e48\u60c5\u51b5\u4e0b\u4f1a\u5931\u6548\u201d\uff0c\u67e5\u8be2\u7ed3\u679c\u53d1\u73b0\uff0c\u6ca1\u6709\u9488\u5bf9\u8fd9\u4e2a\u95ee\u9898\u7684\uff0c\u4f46\u662f\u524d\u4e24\u9879\u7adf\u7136\u662f\u5bf9row_number over partiton by \u505a\u7684\u4e0d\u9519\u7684\u89e3\u91ca\uff0c\u53e6\u5916\u987a\u5e26\u4ecb\u7ecd\u4e86\u53e6\u5916\u4e24\u4e2a\u5177\u6709\u76f8\u540c\u529f\u80fd\u4f46\u662f\u4e0d\u540c\u5206\u7ec4\u6392\u5e8f\u7ed3\u679c\u7684\u65b9\u6cd5\uff0c\u987f\u65f6\u89c9\u5f97\u503c\u5f97\u4e86\u3002\u73b0\u5728\u628a\u8fd9\u4e9b\u89e3\u91ca\u90fd\u653e\u4e0a\u6765\u4ee5\u505a\u5907\u7528\u3002<\/p>\n<p>&lt;<\/p>\n<p>row_number()\u548crownum\u5dee\u4e0d\u591a\uff0c\u529f\u80fd\u66f4\u5f3a\u4e00\u70b9\uff08\u53ef\u4ee5\u5728\u5404\u4e2a\u5206\u7ec4\u5185\u4ece1\u5f00\u65f6\u6392\u5e8f\uff09\uff0e<\/p>\n<p>rank()\u662f\u8df3\u8dc3\u6392\u5e8f\uff0c\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u63a5\u4e0b\u6765\u5c31\u662f\u7b2c\u56db\u540d\uff08\u540c\u6837\u662f\u5728\u5404\u4e2a\u5206\u7ec4\u5185\uff09\uff0e<\/p>\n<p>dense_rank()l\u662f\u8fde\u7eed\u6392\u5e8f\uff0c\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u4ecd\u7136\u8ddf\u7740\u7b2c\u4e09\u540d\u3002\u76f8\u6bd4\u4e4b\u4e0brow_number\u662f\u6ca1\u6709\u91cd\u590d\u503c\u7684<\/p>\n<p>&gt;<\/p>\n<p>row_number() OVER (PARTITION BY COL1 ORDER BY COL2) \u8868\u793a\u6839\u636eCOL1\u5206\u7ec4\uff0c\u5728\u5206\u7ec4\u5185\u90e8\u6839\u636e COL2\u6392\u5e8f\uff0c\u800c\u6b64\u51fd\u6570\u8ba1\u7b97\u7684\u503c\u5c31\u8868\u793a\u6bcf\u7ec4\u5185\u90e8\u6392\u5e8f\u540e\u7684\u987a\u5e8f\u7f16\u53f7\uff08\u7ec4\u5185\u8fde\u7eed\u7684\u552f\u4e00\u7684)<\/p>\n<p>SQL&gt; SELECT G.*, ROW_NUMBER() OVER(PARTITION BY a ,b ORDER BY c DESC) ROWN<br \/>\n2 from (select &#8216;1&#8217; a, &#8216;2&#8217; b, &#8216;1&#8217; c<br \/>\n3 from dual<br \/>\n4 union all<br \/>\n5 select &#8216;1&#8217;, &#8216;2&#8217;, &#8216;2&#8217;<br \/>\n6 from dual<br \/>\n7 union all<br \/>\n8 select &#8216;1&#8217;, &#8216;3&#8217;, &#8216;3&#8217;<br \/>\n9 from dual<br \/>\n10 union all<br \/>\n11 select &#8216;1&#8217;, &#8216;3&#8217;, &#8216;4&#8217;<br \/>\n12 from dual<br \/>\n13 union all<br \/>\n14 select &#8216;1&#8217;, &#8216;4&#8217;, &#8216;5&#8217; from dual<br \/>\n15 union all<br \/>\n16 select &#8216;1&#8217;,&#8217;3&#8242;,&#8217;5&#8217;from dual) G<br \/>\n17 ;<\/p>\n<p>A B C ROWN<br \/>\n&#8211; &#8211; &#8211; &#8212;&#8212;&#8212;-<br \/>\n1 2 2 1<br \/>\n1 2 1 2<br \/>\n1 3 5 1<br \/>\n1 3 4 2<br \/>\n1 3 3 3<br \/>\n1 4 5 1<\/p>\n<p>6 rows selected<\/p>\n<p>\u4e0erownum\u7684\u533a\u522b\u5728\u4e8e\uff1a\u4f7f\u7528rownum\u8fdb\u884c\u6392\u5e8f\u7684\u65f6\u5019\u662f\u5148\u5bf9\u7ed3\u679c\u96c6\u52a0\u5165\u4f2a\u5217rownum\u7136\u540e\u518d\u8fdb\u884c\u6392\u5e8f\uff0c\u800c\u6b64\u51fd\u6570\u5728\u5305\u542b\u6392\u5e8f\u4ece\u53e5\u540e\u662f\u5148\u6392\u5e8f\u518d\u8ba1\u7b97\u884c\u53f7\u7801\uff0e<\/p>\n<p>row_number()\u548crownum\u5dee\u4e0d\u591a\uff0c\u529f\u80fd\u66f4\u5f3a\u4e00\u70b9\uff08\u53ef\u4ee5\u5728\u5404\u4e2a\u5206\u7ec4\u5185\u4ece1\u5f00\u65f6\u6392\u5e8f\uff09\uff0e<\/p>\n<p>rank()\u662f\u8df3\u8dc3\u6392\u5e8f\uff0c\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u63a5\u4e0b\u6765\u5c31\u662f\u7b2c\u56db\u540d\uff08\u540c\u6837\u662f\u5728\u5404\u4e2a\u5206\u7ec4\u5185\uff09\uff0e<\/p>\n<p>dense_rank()l\u662f\u8fde\u7eed\u6392\u5e8f\uff0c\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u4ecd\u7136\u8ddf\u7740\u7b2c\u4e09\u540d\u3002\u76f8\u6bd4\u4e4b\u4e0brow_number\u662f\u6ca1\u6709\u91cd\u590d\u503c\u7684 \uff0e<\/p>\n<p>lag\uff08arg1,arg2,arg3):<br \/>\narg1\u662f\u4ece\u5176\u4ed6\u884c\u8fd4\u56de\u7684\u8868\u8fbe\u5f0f<br \/>\narg2\u662f\u5e0c\u671b\u68c0\u7d22\u7684\u5f53\u524d\u884c\u5206\u533a\u7684\u504f\u79fb\u91cf\u3002\u662f\u4e00\u4e2a\u6b63\u7684\u504f\u79fb\u91cf\uff0c\u65f6\u4e00\u4e2a\u5f80\u56de\u68c0\u7d22\u4ee5\u524d\u7684\u884c\u7684\u6570\u76ee\u3002<br \/>\narg3\u662f\u5728arg2\u8868\u793a\u7684\u6570\u76ee\u8d85\u51fa\u4e86\u5206\u7ec4\u7684\u8303\u56f4\u65f6\u8fd4\u56de\u7684\u503c\u3002<\/p>\n<p>\u8bed\u53e5\u4e00:<\/p>\n<p>select row_number() over(order by sale\/cnt desc) as sort, sale\/cnt<br \/>\nfrom (<br \/>\nselect -60 as sale,3 as cnt from dual union<br \/>\nselect 24 as sale,6 as cnt from dual union<br \/>\nselect 50 as sale,5 as cnt from dual union<br \/>\nselect -20 as sale,2 as cnt from dual union<br \/>\nselect 40 as sale,8 as cnt from dual);<\/p>\n<p>\u6267\u884c\u7ed3\u679c:<\/p>\n<p>SORT SALE\/CNT<br \/>\n&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n1 10<br \/>\n2 5<br \/>\n3 4<br \/>\n4 -10<br \/>\n5 -20<\/p>\n<p>\u8bed\u53e5\u4e8c:\u67e5\u8be2\u5458\u5de5\u7684\u5de5\u8d44,\u6309\u90e8\u95e8\u6392\u5e8f<\/p>\n<p>select ename,sal,row_number() over (partition by deptno order by sal desc) as sal_order from scott.emp;<\/p>\n<p>\u6267\u884c\u7ed3\u679c:<\/p>\n<p>ENAME SAL SAL_ORDER<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\nKING 5000 1<br \/>\nCLARK 2450 2<br \/>\nMILLER 1300 3<br \/>\nSCOTT 3000 1<br \/>\nFORD 3000 2<br \/>\nJONES 2975 3<br \/>\nADAMS 1100 4<br \/>\nSMITH 800 5<br \/>\nBLAKE 2850 1<br \/>\nALLEN 1600 2<br \/>\nTURNER 1500 3<br \/>\nWARD 1250 4<br \/>\nMARTIN 1250 5<br \/>\nJAMES 950 6<\/p>\n<p>\u5df2\u9009\u62e914\u884c\u3002<\/p>\n<p>\u8bed\u53e5\u4e09:\u67e5\u8be2\u6bcf\u4e2a\u90e8\u95e8\u7684\u6700\u9ad8\u5de5\u8d44<\/p>\n<p>select deptno,ename,sal from<br \/>\n(select deptno,ename,sal,row_number() over (partition by deptno order by sal desc) as sal_order<br \/>\nfrom scott.emp) where sal_order &lt;2;<\/p>\n<p>\u6267\u884c\u7ed3\u679c:<\/p>\n<p>DEPTNO ENAME SAL<br \/>\n&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;-<br \/>\n10 KING 5000<br \/>\n20 SCOTT 3000<br \/>\n30 BLAKE 2850<\/p>\n<p>\u5df2\u9009\u62e93\u884c\u3002<\/p>\n<p>\u8bed\u53e5\u56db\uff1a<\/p>\n<p>select deptno,sal,rank() over (partition by deptno order by sal) as rank_order from scott.emp order by deptno;<\/p>\n<p>\u6267\u884c\u7ed3\u679c:<\/p>\n<p>DEPTNO SAL RANK_ORDER<br \/>\n&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n10 1300 1<br \/>\n10 2450 2<br \/>\n10 5000 3<br \/>\n20 800 1<br \/>\n20 1100 2<br \/>\n20 2975 3<br \/>\n20 3000 4<br \/>\n20 3000 4<br \/>\n30 950 1<br \/>\n30 1250 2<br \/>\n30 1250 2<br \/>\n30 1500 4<br \/>\n30 1600 5<br \/>\n30 2850 6<\/p>\n<p>\u5df2\u9009\u62e914\u884c\u3002<\/p>\n<p>\u8bed\u53e5\u4e94\uff1a<\/p>\n<p>select deptno,sal,dense_rank() over(partition by deptno order by sal) as dense_rank_order from scott.emp order by deptn;<\/p>\n<p>\u6267\u884c\u7ed3\u679c\uff1a<\/p>\n<p>DEPTNO SAL DENSE_RANK_ORDER<br \/>\n&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\n10 1300 1<br \/>\n10 2450 2<br \/>\n10 5000 3<br \/>\n20 800 1<br \/>\n20 1100 2<br \/>\n20 2975 3<br \/>\n20 3000 4<br \/>\n20 3000 4<br \/>\n30 950 1<br \/>\n30 1250 2<br \/>\n30 1250 2<br \/>\n30 1500 3<br \/>\n30 1600 4<br \/>\n30 2850 5<\/p>\n<p>\u5df2\u9009\u62e914\u884c\u3002<\/p>\n<p>\u8bed\u53e5\u516d\uff1a<\/p>\n<p>select deptno,ename,sal,lag(ename,1,null) over(partition by deptno order by ename) as lag_ from scott.emp order by deptno;<\/p>\n<p>\u6267\u884c\u7ed3\u679c\uff1a<\/p>\n<p>DEPTNO ENAME SAL LAG_<br \/>\n&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n10 CLARK 2450<br \/>\n10 KING 5000 CLARK<br \/>\n10 MILLER 1300 KING<br \/>\n20 ADAMS 1100<br \/>\n20 FORD 3000 ADAMS<br \/>\n20 JONES 2975 FORD<br \/>\n20 SCOTT 3000 JONES<br \/>\n20 SMITH 800 SCOTT<br \/>\n30 ALLEN 1600<br \/>\n30 BLAKE 2850 ALLEN<br \/>\n30 JAMES 950 BLAKE<br \/>\n30 MARTIN 1250 JAMES<br \/>\n30 TURNER 1500 MARTIN<br \/>\n30 WARD 1250 TURNER<\/p>\n<p>\u4ee5\u4e0a\u7528\u4f8b\u548c\u8be6\u7ec6\u4ecb\u7ecd\u6765\u81ea\u300ahttp:\/\/www.blogjava.net\/kxbin\/articles\/360195.html\u300b<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u5929\u5728\u7fa4\u91cc\u8ddf\u4e00\u7fa4\u540c\u5b66\u804a\u5929\uff0c\u604d\u7136\u53d1\u73b0\u6709\u4e2a\u540c\u5b66\u6b63\u5728\u671ddba\u7684\u65b9\u5411\u53d1\u5c55\uff0c\u6b63\u597d\u8111\u5b50\u91cc\u6709\u4e2a\u4ee5\u524d\u7684\u95ee\u9898\u60f3\u8981\u95ee\u4e00\u4e0b\uff0c\u95ee\u9898\u662f\uff1a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-73","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dongchangbin.net.cn\/?p=73\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"\u4eca\u5929\u5728\u7fa4\u91cc\u8ddf\u4e00\u7fa4\u540c\u5b66\u804a\u5929\uff0c\u604d\u7136\u53d1\u73b0\u6709\u4e2a\u540c\u5b66\u6b63\u5728\u671ddba\u7684\u65b9\u5411\u53d1\u5c55\uff0c\u6b63\u597d\u8111\u5b50\u91cc\u6709\u4e2a\u4ee5\u524d\u7684\u95ee\u9898\u60f3\u8981\u95ee\u4e00\u4e0b\uff0c\u95ee\u9898\u662f\uff1a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dongchangbin.net.cn\/?p=73\" \/>\n<meta property=\"og:site_name\" content=\"Dong&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-12T03:36:27+00:00\" \/>\n<meta name=\"author\" content=\"Dong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dong\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73\"},\"author\":{\"name\":\"Dong\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae\"},\"headline\":\"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd\",\"datePublished\":\"2013-03-12T03:36:27+00:00\",\"dateModified\":\"2013-03-12T03:36:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73\"},\"wordCount\":422,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dongchangbin.net.cn\/?p=73#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73\",\"url\":\"https:\/\/www.dongchangbin.net.cn\/?p=73\",\"name\":\"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#website\"},\"datePublished\":\"2013-03-12T03:36:27+00:00\",\"dateModified\":\"2013-03-12T03:36:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dongchangbin.net.cn\/?p=73\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/?p=73#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.dongchangbin.net.cn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#website\",\"url\":\"https:\/\/www.dongchangbin.net.cn\/\",\"name\":\"Dong&#039;s Blog\",\"description\":\"\u6162\u6162\u6765\uff0c\u6bd4\u8f83\u5feb\",\"publisher\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dongchangbin.net.cn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae\",\"name\":\"Dong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d0ac155d3e1aba6eca6a0a2bb3cdba1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d0ac155d3e1aba6eca6a0a2bb3cdba1?s=96&d=mm&r=g\",\"caption\":\"Dong\"},\"logo\":{\"@id\":\"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/www.dongchangbin.net.cn\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dongchangbin.net.cn\/?p=73","og_locale":"zh_CN","og_type":"article","og_title":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog","og_description":"\u4eca\u5929\u5728\u7fa4\u91cc\u8ddf\u4e00\u7fa4\u540c\u5b66\u804a\u5929\uff0c\u604d\u7136\u53d1\u73b0\u6709\u4e2a\u540c\u5b66\u6b63\u5728\u671ddba\u7684\u65b9\u5411\u53d1\u5c55\uff0c\u6b63\u597d\u8111\u5b50\u91cc\u6709\u4e2a\u4ee5\u524d\u7684\u95ee\u9898\u60f3\u8981\u95ee\u4e00\u4e0b\uff0c\u95ee\u9898\u662f\uff1a [&hellip;]","og_url":"https:\/\/www.dongchangbin.net.cn\/?p=73","og_site_name":"Dong&#039;s Blog","article_published_time":"2013-03-12T03:36:27+00:00","author":"Dong","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Dong","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dongchangbin.net.cn\/?p=73#article","isPartOf":{"@id":"https:\/\/www.dongchangbin.net.cn\/?p=73"},"author":{"name":"Dong","@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae"},"headline":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd","datePublished":"2013-03-12T03:36:27+00:00","dateModified":"2013-03-12T03:36:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dongchangbin.net.cn\/?p=73"},"wordCount":422,"commentCount":0,"publisher":{"@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dongchangbin.net.cn\/?p=73#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dongchangbin.net.cn\/?p=73","url":"https:\/\/www.dongchangbin.net.cn\/?p=73","name":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd - Dong&#039;s Blog","isPartOf":{"@id":"https:\/\/www.dongchangbin.net.cn\/#website"},"datePublished":"2013-03-12T03:36:27+00:00","dateModified":"2013-03-12T03:36:27+00:00","breadcrumb":{"@id":"https:\/\/www.dongchangbin.net.cn\/?p=73#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dongchangbin.net.cn\/?p=73"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dongchangbin.net.cn\/?p=73#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.dongchangbin.net.cn\/"},{"@type":"ListItem","position":2,"name":"row_number() over()\u7528\u4f8b\u53ca\u76f8\u8fd1\u51fd\u6570rank()\u548cdense_rank()\u7684\u4ecb\u7ecd"}]},{"@type":"WebSite","@id":"https:\/\/www.dongchangbin.net.cn\/#website","url":"https:\/\/www.dongchangbin.net.cn\/","name":"Dong&#039;s Blog","description":"\u6162\u6162\u6765\uff0c\u6bd4\u8f83\u5feb","publisher":{"@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dongchangbin.net.cn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/1420649ce898d888fea55ef4fa6e8fae","name":"Dong","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d0ac155d3e1aba6eca6a0a2bb3cdba1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d0ac155d3e1aba6eca6a0a2bb3cdba1?s=96&d=mm&r=g","caption":"Dong"},"logo":{"@id":"https:\/\/www.dongchangbin.net.cn\/#\/schema\/person\/image\/"},"url":"https:\/\/www.dongchangbin.net.cn\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/73"}],"collection":[{"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=73"}],"version-history":[{"count":0,"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/73\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dongchangbin.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}