{"id":4645,"date":"2024-03-14T01:43:32","date_gmt":"2024-03-14T01:43:32","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/"},"modified":"2025-07-31T11:08:12","modified_gmt":"2025-07-31T11:08:12","slug":"how-to-find-the-nth-highest-or-lowest-value-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/","title":{"rendered":"MySQL Nth Highest &#038; Lowest Values: Query Guide"},"content":{"rendered":"<p>To search for the Nth highest or Nth lowest value, you can use MySQL&#8217;s subquery and ORDER BY statement.<\/p>\n<p>To find the Nth highest value, you can use the following query statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">DISTINCT<\/span> column_name \r\n<span class=\"hljs-keyword\">FROM<\/span> table_name \r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> column_name <span class=\"hljs-keyword\">DESC<\/span> \r\nLIMIT N<span class=\"hljs-number\">-1<\/span>, <span class=\"hljs-number\">1<\/span>;\r\n<\/code><\/pre>\n<p>To find the Nth lowest value, you can use the following query statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">DISTINCT<\/span> column_name \r\n<span class=\"hljs-keyword\">FROM<\/span> table_name \r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> column_name <span class=\"hljs-keyword\">ASC<\/span> \r\nLIMIT N<span class=\"hljs-number\">-1<\/span>, <span class=\"hljs-number\">1<\/span>;\r\n<\/code><\/pre>\n<p>In the above query, column_name is the name of the column to be searched, table_name is the name of the table to be queried, and N is the position of the value to be found. The ORDER BY statement is used to sort the results in ascending or descending order by column, with DESC indicating descending order and ASC indicating ascending order. LIMIT is used to limit the number of results, with the first parameter as the offset and the second parameter as the number of rows to return.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To search for the Nth highest or Nth lowest value, you can use MySQL&#8217;s subquery and ORDER BY statement. To find the Nth highest value, you can use the following query statement: SELECT DISTINCT column_name FROM table_name ORDER BY column_name DESC LIMIT N-1, 1; To find the Nth lowest value, you can use the following [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[298,4352,4397,4398,1845],"class_list":["post-4645","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-mysql","tag-mysql-subquery","tag-nth-highest","tag-nth-lowest","tag-sql-queries"],"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>MySQL Nth Highest &amp; Lowest Values: Query Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.\" \/>\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-find-the-nth-highest-or-lowest-value-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Nth Highest &amp; Lowest Values: Query Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\" \/>\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-14T01:43:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T11:08:12+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\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-find-the-nth-highest-or-lowest-value-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"MySQL Nth Highest &#038; Lowest Values: Query Guide\",\"datePublished\":\"2024-03-14T01:43:32+00:00\",\"dateModified\":\"2025-07-31T11:08:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\"},\"wordCount\":144,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"MySQL\",\"MySQL subquery\",\"Nth highest\",\"Nth lowest\",\"SQL Queries\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\",\"name\":\"MySQL Nth Highest & Lowest Values: Query Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:43:32+00:00\",\"dateModified\":\"2025-07-31T11:08:12+00:00\",\"description\":\"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Nth Highest &#038; Lowest Values: Query Guide\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Nth Highest & Lowest Values: Query Guide - Blog - Silicon Cloud","description":"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.","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-find-the-nth-highest-or-lowest-value-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Nth Highest & Lowest Values: Query Guide","og_description":"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:43:32+00:00","article_modified_time":"2025-07-31T11:08:12+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"MySQL Nth Highest &#038; Lowest Values: Query Guide","datePublished":"2024-03-14T01:43:32+00:00","dateModified":"2025-07-31T11:08:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/"},"wordCount":144,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["MySQL","MySQL subquery","Nth highest","Nth lowest","SQL Queries"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/","name":"MySQL Nth Highest & Lowest Values: Query Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:43:32+00:00","dateModified":"2025-07-31T11:08:12+00:00","description":"Learn how to find the Nth highest\/lowest value in MySQL with subqueries and ORDER BY. Quick SQL examples included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-find-the-nth-highest-or-lowest-value-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Nth Highest &#038; Lowest Values: Query Guide"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4645","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4645"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4645\/revisions"}],"predecessor-version":[{"id":149334,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4645\/revisions\/149334"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}