{"id":2985,"date":"2022-11-05T11:51:18","date_gmt":"2022-11-05T03:51:18","guid":{"rendered":"https:\/\/www.citerp.com.tw\/citwp2\/?p=2985"},"modified":"2022-11-05T15:57:31","modified_gmt":"2022-11-05T07:57:31","slug":"sql-20","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/","title":{"rendered":"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()"},"content":{"rendered":"\n<p> <strong>MSSQL<\/strong> \u9664\u4e86<strong> <a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-19\/\" target=\"_blank\" rel=\"noreferrer noopener\">ORDER BY<\/a><\/strong> \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 <strong>ROW_NUMBER()<\/strong> \uff0c\u914d\u5408 <strong>PARTITION BY<\/strong> \u505a\u5206\u7fa4\u7d44\u6392\u5e8f\u3002<strong>ROW_NUMBER()<\/strong> \u6703\u5c07\u67e5\u8a62\u51fa\u4f86\u7684\u6bcf\u4e00\u5217\u8cc7\u6599\u52a0\u4e0a\u4e00\u500b<strong>\u5e8f\u865f<\/strong>(\u5f9e1\u958b\u59cb\u7d2f\u52a0)\uff0c\u4e14<strong>\u5e8f\u865f\u4e0d\u6703\u91cd\u8907<\/strong>\u3002\u63a5\u4e0b\u4f86\u5c31\u70ba\u5927\u5bb6\u4ecb\u7d39\u7528\u6cd5\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>ROW_NUMBER() <\/strong>-\u5206\u7fa4\u7d44\u6392\u5e8f<\/h3>\n\n\n\n<p>\u9996\u5148\u6211\u5011\u5148\u5efa\u4e00\u500b\u8cc7\u6599\u8868(<strong> <\/strong><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/18\/sql-18\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>CREATE <\/strong> <strong> TABLE<\/strong><\/a><strong> <\/strong>) \u5982\u4e0b:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE dbo.Cars(stype VARCHAR(15), Price MONEY, Color VARCHAR(10), YearM date);  \nINSERT dbo.Cars VALUES  \n    ('\u8f4e\u8eca', 20000, 'red', '2010-01-01'), ('\u655e\u7bf7\u8eca', 35000, 'blue', '2000-12-01'),   \n    ('\u8f4e\u8dd1\u8eca', 25000, 'red', '2020-01-01'), ('\u9eb5\u5305\u8eca', 16000, 'blue', '2015-01-01'); <\/code><\/pre>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u6211\u5011<strong>\u4f9d\u984f\u8272\u53ca\u50f9\u9322<\/strong>\u4f86\u505a<strong>\u7fa4\u7d44\u6392\u5e8f<\/strong>\uff0c\u6211\u5011\u53ef\u4ee5\u770b\u5230\u52a0\u4e86 <strong>PARTITION BY <\/strong>\u5f8c\uff0c\u7522\u751f\u7684<strong>ROW_ID<\/strong>\u6b04\u4f4d\uff0c\u6703\u4f9d\u7167\u7d44\u5225\u4f86\u7522\u751f\u6d41\u6c34\u865f\u3002<\/p>\n\n\n\n<p> \u8a9e\u6cd5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select ROW_NUMBER() OVER (ORDER BY Color ASC,Price desc) as ROW_ID ,* from Cars \r\n\r\nselect ROW_NUMBER() OVER (PARTITION BY Color order by Price desc) as ROW_ID ,* from Cars<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"128\" height=\"128\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit.png\" alt=\"\" class=\"wp-image-339\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit.png 128w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit-88x88.png 88w\" sizes=\"auto, (max-width: 128px) 100vw, 128px\" \/><\/figure>\n\n\n\n<p> \u5be6\u4f5c\uff1a <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1.png\" rel=\"lightbox[2985]\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"514\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1-1024x514.png\" alt=\"\" class=\"wp-image-2987\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1-1024x514.png 1024w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1-300x151.png 300w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1-768x386.png 768w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-1.png 1111w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n\t<ins class=\"adsbygoogle\" style=\"display:block\" data-ad-client=\"ca-pub-7536970353732438\" data-ad-slot=\"2906002114\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u5982\u679c\u6211\u5011\u53ea\u8981\u5728<strong>\u6bcf\u7a2e\u984f\u8272\u4e2d\u5217\u51fa\u50f9\u9322\u6700\u9ad8\u7684\u4e00\u8f1b\u8eca<\/strong>\uff0c\u8981\u600e\u5011\u4e0b\u8a9e\u6cd5\u5462 ?<\/p>\n\n\n\n<p> \u8a9e\u6cd5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select t1.*\r\n from (select ROW_NUMBER() OVER (PARTITION BY Color order by Price desc) as ROW_ID ,* from Cars) as t1\r\n where t1.ROW_ID = 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"128\" height=\"128\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit.png\" alt=\"\" class=\"wp-image-339\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit.png 128w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/Home-0020-cit-88x88.png 88w\" sizes=\"auto, (max-width: 128px) 100vw, 128px\" \/><\/figure>\n\n\n\n<p> \u5be6\u4f5c\uff1a <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"479\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-2-1024x479.png\" alt=\"\" class=\"wp-image-2988\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-2-1024x479.png 1024w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-2-300x140.png 300w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-2-768x359.png 768w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-20-2.png 1196w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n\t<ins class=\"adsbygoogle\" style=\"display:block\" data-ad-client=\"ca-pub-7536970353732438\" data-ad-slot=\"2906002114\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><strong><span data-fontsize=\"24\" style=\"font-size: 24px;\" class=\"qubely-custom-font\"> \ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/?p=2912\" target=\"_blank\" rel=\"noreferrer noopener\">[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE TABLE<\/a><\/span><\/strong><\/p>\n\n\n\n<p> <strong><span data-fontsize=\"24\" style=\"font-size: 24px;\" class=\"qubely-custom-font\">\ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/09\/08\/sql-12\/\" target=\"_blank\" rel=\"noreferrer noopener\">[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e<\/a><\/span><\/strong><\/p>\n\n\n\n<p> <strong><span data-fontsize=\"24\" style=\"font-size: 24px;\" class=\"qubely-custom-font\">\ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/21\/sql-006\/\" target=\"_blank\" rel=\"noreferrer noopener\">[MS-SQL]\u53d6\u51fa\u5e74\u6708\u65e5DATEPART()<\/a><\/span><\/strong><\/p>\n\n\n\n<p> <span data-fontsize=\"24\" style=\"font-size: 24px;\" class=\"qubely-custom-font\">\ud83d\udc49<strong><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-19\/\" target=\"_blank\" rel=\"noreferrer noopener\">[MS-SQL]\u6392\u5e8f\u67e5\u8a62 ORDER BY\u3001\u6307\u5b9a\u67e5\u8a62\u8cc7\u6599\u5217\u6578\u76ee TOP<\/a><\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL \u9664\u4e86 ORDER BY \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 ROW_NUMBER() \uff0c\u914d\u5408 PARTITION &#8230; <a title=\"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc [MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()\">\u95b1\u8b80\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":2990,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","footnotes":""},"categories":[48],"tags":[30],"class_list":["post-2985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-sql","tag-sql"],"qubely_featured_image_url":{"full":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"portraits":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"medium":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"medium_large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"1536x1536":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"2048x2048":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"qubely_landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"qubely_portrait":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png",128,128,false],"qubely_thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0-128x100.png",128,100,true]},"qubely_author":{"display_name":"\u5927\u53d4","author_link":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"},"qubely_comment":0,"qubely_category":"<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/category\/ms-sql\/\" rel=\"category tag\">MS-SQL<\/a>","qubely_excerpt":"MSSQL \u9664\u4e86 ORDER BY \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 ROW_NUMBER() \uff0c\u914d\u5408 PARTITION...","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER() - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4<\/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.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER() - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"og:description\" content=\"MSSQL \u9664\u4e86 ORDER BY \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 ROW_NUMBER() \uff0c\u914d\u5408 PARTITION ... \u95b1\u8b80\u66f4\u591a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/\" \/>\n<meta property=\"og:site_name\" content=\"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-05T03:51:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-05T07:57:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png\" \/>\n\t<meta property=\"og:image:width\" content=\"128\" \/>\n\t<meta property=\"og:image:height\" content=\"128\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5927\u53d4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/\",\"name\":\"\\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"description\":\"\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u5584\\u7528\\u7db2\\u8def\\u8cc7\\u6e90\\u627e\\u5230\\u66f4\\u7f8e\\u597d\\u7684\\u751f\\u6d3b..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#primaryimage\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png\",\"contentUrl\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png\",\"width\":128,\"height\":128},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#webpage\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/\",\"name\":\"[MS-SQL]\\u5206\\u7fa4\\u7d44\\u6392\\u5e8fROW_NUMBER() - \\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"isPartOf\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#primaryimage\"},\"datePublished\":\"2022-11-05T03:51:18+00:00\",\"dateModified\":\"2022-11-05T07:57:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\\u9996\\u9801\",\"item\":\"https:\/\/www.citerp.com.tw\/citwp2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[MS-SQL]\\u5206\\u7fa4\\u7d44\\u6392\\u5e8fROW_NUMBER()\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\",\"name\":\"\\u5927\\u53d4\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"caption\":\"\\u5927\\u53d4\"},\"sameAs\":[\"http:\/\/localhost\/wp2\"],\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER() - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","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.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/","og_locale":"zh_TW","og_type":"article","og_title":"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER() - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","og_description":"MSSQL \u9664\u4e86 ORDER BY \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 ROW_NUMBER() \uff0c\u914d\u5408 PARTITION ... \u95b1\u8b80\u66f4\u591a","og_url":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/","og_site_name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","article_published_time":"2022-11-05T03:51:18+00:00","article_modified_time":"2022-11-05T07:57:31+00:00","og_image":[{"width":128,"height":128,"url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u5927\u53d4","Est. reading time":"2 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website","url":"https:\/\/www.citerp.com.tw\/citwp2\/","name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","description":"\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u5584\u7528\u7db2\u8def\u8cc7\u6e90\u627e\u5230\u66f4\u7f8e\u597d\u7684\u751f\u6d3b..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-TW"},{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#primaryimage","inLanguage":"zh-TW","url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png","contentUrl":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sq1-0.png","width":128,"height":128},{"@type":"WebPage","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#webpage","url":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/","name":"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER() - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","isPartOf":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#primaryimage"},"datePublished":"2022-11-05T03:51:18+00:00","dateModified":"2022-11-05T07:57:31+00:00","author":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007"},"breadcrumb":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-20\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/www.citerp.com.tw\/citwp2\/"},{"@type":"ListItem","position":2,"name":"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()"}]},{"@type":"Person","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007","name":"\u5927\u53d4","image":{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo","inLanguage":"zh-TW","url":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","caption":"\u5927\u53d4"},"sameAs":["http:\/\/localhost\/wp2"],"url":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/2985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/comments?post=2985"}],"version-history":[{"count":3,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/2985\/revisions"}],"predecessor-version":[{"id":2995,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/2985\/revisions\/2995"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media\/2990"}],"wp:attachment":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media?parent=2985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/categories?post=2985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/tags?post=2985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}