{"id":23231,"date":"2024-03-16T01:02:26","date_gmt":"2024-03-16T01:02:26","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/"},"modified":"2024-03-22T00:46:23","modified_gmt":"2024-03-22T00:46:23","slug":"basic-usage-of-rownum-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/","title":{"rendered":"Basic usage of Rownum in Oracle"},"content":{"rendered":"<p>\u5728Oracle\u4e2d\uff0crownum\u662f\u4e00\u4e2a\u4f2a\u5217\uff0c\u7528\u4e8e\u7ed9\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\u5206\u914d\u4e00\u4e2a\u552f\u4e00\u7684\u884c\u53f7\u3002<\/p>\n<p>The basic usage of rownum is as follows:<\/p>\n<ol>\n<li>row number<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> \r\n<span class=\"hljs-keyword\">FROM<\/span> table_name\r\n<span class=\"hljs-keyword\">WHERE<\/span> rownum <span class=\"hljs-operator\">&lt;=<\/span> <span class=\"hljs-number\">10<\/span>;\r\n<\/code><\/pre>\n<p>The above example will return the first 10 rows of the result set.<\/p>\n<ol>\n<li>row number<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> \r\n<span class=\"hljs-keyword\">FROM<\/span> (<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> table_name <span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> column_name) \r\n<span class=\"hljs-keyword\">WHERE<\/span> rownum <span class=\"hljs-operator\">&lt;=<\/span> <span class=\"hljs-number\">10<\/span>;\r\n<\/code><\/pre>\n<p>The above example will return the top 10 rows in the result set sorted by the specified column.<\/p>\n<p>It&#8217;s important to note that rownum is assigned to rows before the query results are returned, so you cannot directly reference the rownum column in the SELECT statement for filtering conditions, or else an error will occur. If you need to filter by row number, you can use a subquery.<\/p>\n<p>Also important to note is that rownum is assigned row numbers before the result set is returned, so when using rownum for filtering or sorting, it must be used within a subquery, otherwise the results may be incorrect.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728Oracle\u4e2d\uff0crownum\u662f\u4e00\u4e2a\u4f2a\u5217\uff0c\u7528\u4e8e\u7ed9\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\u5206\u914d\u4e00\u4e2a\u552f\u4e00\u7684\u884c\u53f7\u3002 The basic usage of rownum is as follows: row number SELECT * FROM table_name WHERE rownum &lt;= 10; The above example will return the first 10 rows of the result set. row number SELECT * FROM (SELECT * FROM table_name ORDER BY column_name) WHERE rownum &lt;= 10; The above example will return the top [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-23231","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Basic usage of Rownum in Oracle - Blog - Silicon Cloud<\/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.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basic usage of Rownum in Oracle\" \/>\n<meta property=\"og:description\" content=\"\u5728Oracle\u4e2d\uff0crownum\u662f\u4e00\u4e2a\u4f2a\u5217\uff0c\u7528\u4e8e\u7ed9\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\u5206\u914d\u4e00\u4e2a\u552f\u4e00\u7684\u884c\u53f7\u3002 The basic usage of rownum is as follows: row number SELECT * FROM table_name WHERE rownum &lt;= 10; The above example will return the first 10 rows of the result set. row number SELECT * FROM (SELECT * FROM table_name ORDER BY column_name) WHERE rownum &lt;= 10; The above example will return the top [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T01:02:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T00:46:23+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"Basic usage of Rownum in Oracle\",\"datePublished\":\"2024-03-16T01:02:26+00:00\",\"dateModified\":\"2024-03-22T00:46:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\"},\"wordCount\":138,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\",\"name\":\"Basic usage of Rownum in Oracle - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T01:02:26+00:00\",\"dateModified\":\"2024-03-22T00:46:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Basic usage of Rownum in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Basic usage of Rownum in Oracle - Blog - Silicon Cloud","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.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Basic usage of Rownum in Oracle","og_description":"\u5728Oracle\u4e2d\uff0crownum\u662f\u4e00\u4e2a\u4f2a\u5217\uff0c\u7528\u4e8e\u7ed9\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\u5206\u914d\u4e00\u4e2a\u552f\u4e00\u7684\u884c\u53f7\u3002 The basic usage of rownum is as follows: row number SELECT * FROM table_name WHERE rownum &lt;= 10; The above example will return the first 10 rows of the result set. row number SELECT * FROM (SELECT * FROM table_name ORDER BY column_name) WHERE rownum &lt;= 10; The above example will return the top [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T01:02:26+00:00","article_modified_time":"2024-03-22T00:46:23+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"Basic usage of Rownum in Oracle","datePublished":"2024-03-16T01:02:26+00:00","dateModified":"2024-03-22T00:46:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/"},"wordCount":138,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/","name":"Basic usage of Rownum in Oracle - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T01:02:26+00:00","dateModified":"2024-03-22T00:46:23+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/basic-usage-of-rownum-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Basic usage of Rownum in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=23231"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23231\/revisions"}],"predecessor-version":[{"id":57196,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23231\/revisions\/57196"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=23231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=23231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=23231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}