{"id":21377,"date":"2024-03-15T21:58:46","date_gmt":"2024-03-15T21:58:46","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/"},"modified":"2024-03-21T20:20:26","modified_gmt":"2024-03-21T20:20:26","slug":"how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/","title":{"rendered":"How to resolve duplicate values when sorting by Oracle ROWNUM?"},"content":{"rendered":"<p>When using ROWNUM to sort the result set, there may be duplicate values because ROWNUM is calculated after the query results are returned, so it is not possible to determine the ROWNUM value for each row before sorting. To solve this issue, a subquery can be used. For example, if you have a table named &#8220;employees&#8221; with a column named &#8220;salary&#8221; and you want to sort the salaries and retrieve the top 10 employees:<\/p>\n<pre class=\"post-pre\">SELECT&nbsp;*&nbsp;FROM&nbsp;(<p><\/p><p><\/p><p>&nbsp;&nbsp;SELECT&nbsp;*&nbsp;FROM&nbsp;employees&nbsp;ORDER&nbsp;BY&nbsp;salary&nbsp;DESC<\/p><p>)&nbsp;WHERE&nbsp;ROWNUM&nbsp;&lt;=&nbsp;10;<\/p><\/pre>\n<p>First, the query sorts the salaries in descending order, then uses the results as a subquery, and filters using ROWNUM. This ensures the correct sorting of the results and allows you to retrieve data for the top 10 employees. It is important to note that if you want to get unique results, you can use the DISTINCT keyword. For example:<\/p>\n<pre class=\"post-pre\">SELECT&nbsp;DISTINCT&nbsp;salary&nbsp;FROM&nbsp;(<p><\/p><p><\/p><p>&nbsp;&nbsp;SELECT&nbsp;*&nbsp;FROM&nbsp;employees&nbsp;ORDER&nbsp;BY&nbsp;salary&nbsp;DESC<\/p><p>)&nbsp;WHERE&nbsp;ROWNUM&nbsp;&lt;=&nbsp;10;<\/p><\/pre>\n<p>This will ensure that the resulting values only include non-repeating salaries.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using ROWNUM to sort the result set, there may be duplicate values because ROWNUM is calculated after the query results are returned, so it is not possible to determine the ROWNUM value for each row before sorting. To solve this issue, a subquery can be used. For example, if you have a table named [&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-21377","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>How to resolve duplicate values when sorting by Oracle ROWNUM? - 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\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to resolve duplicate values when sorting by Oracle ROWNUM?\" \/>\n<meta property=\"og:description\" content=\"When using ROWNUM to sort the result set, there may be duplicate values because ROWNUM is calculated after the query results are returned, so it is not possible to determine the ROWNUM value for each row before sorting. To solve this issue, a subquery can be used. For example, if you have a table named [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\" \/>\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-15T21:58:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T20:20:26+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\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How to resolve duplicate values when sorting by Oracle ROWNUM?\",\"datePublished\":\"2024-03-15T21:58:46+00:00\",\"dateModified\":\"2024-03-21T20:20:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\"},\"wordCount\":153,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\",\"name\":\"How to resolve duplicate values when sorting by Oracle ROWNUM? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T21:58:46+00:00\",\"dateModified\":\"2024-03-21T20:20:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to resolve duplicate values when sorting by Oracle ROWNUM?\"}]},{\"@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":"How to resolve duplicate values when sorting by Oracle ROWNUM? - 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\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/","og_locale":"en_US","og_type":"article","og_title":"How to resolve duplicate values when sorting by Oracle ROWNUM?","og_description":"When using ROWNUM to sort the result set, there may be duplicate values because ROWNUM is calculated after the query results are returned, so it is not possible to determine the ROWNUM value for each row before sorting. To solve this issue, a subquery can be used. For example, if you have a table named [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T21:58:46+00:00","article_modified_time":"2024-03-21T20:20:26+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\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How to resolve duplicate values when sorting by Oracle ROWNUM?","datePublished":"2024-03-15T21:58:46+00:00","dateModified":"2024-03-21T20:20:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/"},"wordCount":153,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/","name":"How to resolve duplicate values when sorting by Oracle ROWNUM? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T21:58:46+00:00","dateModified":"2024-03-21T20:20:26+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-resolve-duplicate-values-when-sorting-by-oracle-rownum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to resolve duplicate values when sorting by Oracle ROWNUM?"}]},{"@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\/21377","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=21377"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21377\/revisions"}],"predecessor-version":[{"id":55236,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21377\/revisions\/55236"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=21377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=21377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=21377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}