{"id":1737,"date":"2018-11-11T16:16:47","date_gmt":"2018-11-11T09:16:47","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=1737"},"modified":"2024-04-16T09:52:53","modified_gmt":"2024-04-16T02:52:53","slug":"sqlite-dense_rank","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/","title":{"rendered":"SQLite DENSE_RANK() Function"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the SQLite <code>DENSE_RANK()<\/code> function to compute the rank of a row in an ordered set of rows.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to SQLite DENSE_RANK() function<\/h2>\n\n\n\n<p>The <code>DENSE_RANK()<\/code> is a <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/\">window function<\/a> that computes the rank of a row in an ordered set of rows and returns the rank as an integer. The ranks are consecutive integers starting from 1. Rows with equal values receive the same rank. And rank values are not skipped in case of ties.<\/p>\n\n\n\n<p>Here is the syntax of the <code>DENSE_RANK()<\/code> function:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">DENSE_RANK() OVER (\n\tPARTITION BY expression1, expression2,...\n\tORDER BY expression1 &#91;ASC | DESC], expression2,..\n)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <code>PARTITION BY<\/code> clause divides the result set into partitions to which the function applies. If you omit the <code>PARTITION BY<\/code> clause, the function treats the whole result set as a single partition.<\/li>\n\n\n\n<li>The <code>ORDER BY<\/code> specifies the order of rows in each partition to which the function applies.<\/li>\n\n\n\n<li>The <code>DENSE_RANK()<\/code> function applies to each partition separately and recomputes the rank for each partition.<\/li>\n<\/ul>\n\n\n\n<p>The <code>DENSE_RANK()<\/code> function is useful in case you want to create top-N and bottom-N reports.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLite DENSE_RANK() function examples<\/h2>\n\n\n\n<p>Let&#8217;s take some examples of using the<code>DENSE_RANK()<\/code> function to understand it better.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Using SQLite DENSE_RANK() function over the result set example<\/h3>\n\n\n\n<p>First, <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-create-table\/\">create a new table<\/a> named <code>DenseRankDemo<\/code> for demonstration:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> DenseRankDemo (\n\tVal <span class=\"hljs-built_in\">TEXT<\/span>\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Second, <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\">insert<\/a> data into the <code>DenseRankDemo<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> DenseRankDemo(Val)\n<span class=\"hljs-keyword\">VALUES<\/span>(<span class=\"hljs-string\">'A'<\/span>),(<span class=\"hljs-string\">'B'<\/span>),(<span class=\"hljs-string\">'C'<\/span>),(<span class=\"hljs-string\">'C'<\/span>),(<span class=\"hljs-string\">'D'<\/span>),(<span class=\"hljs-string\">'D'<\/span>),(<span class=\"hljs-string\">'E'<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Third, use the <code>DENSE_RANK()<\/code> function to compute a rank for each row:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\n\tVal,\n\t<span class=\"hljs-keyword\">DENSE_RANK<\/span> () <span class=\"hljs-keyword\">OVER<\/span> ( \n\t\t<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> Val ) \n\tValRank \n<span class=\"hljs-keyword\">FROM<\/span>\n\tDenseRankDemo;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"120\" height=\"163\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\" alt=\"SQLite DENSE_RANK Function example\" class=\"wp-image-1738\"\/><\/figure>\n\n\n\n<p>In the output:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Rows with the same value receive the same rank.<\/li>\n\n\n\n<li>There are no gaps in rank values.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2) Using DENSE_RANK() function with partitions <\/h3>\n\n\n\n<p>The following statement uses the <code>DENSE_RANK()<\/code> function to compute the rank for each track in each album based on the track&#8217;s length:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\n\tAlbumId,\n\t<span class=\"hljs-keyword\">Name<\/span>,\n\tMilliseconds,\n\t<span class=\"hljs-keyword\">DENSE_RANK<\/span> () <span class=\"hljs-keyword\">OVER<\/span> ( \n\t\t<span class=\"hljs-keyword\">PARTITION<\/span> <span class=\"hljs-keyword\">BY<\/span> AlbumId \n\t\t<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> Milliseconds \n\t) LengthRank\n<span class=\"hljs-keyword\">FROM<\/span>\n\ttracks;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The following picture shows the partial output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"513\" height=\"307\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-with-PARTITION-BY-clause-example.png\" alt=\"SQLite DENSE_RANK Function with PARTITION BY clause example\" class=\"wp-image-1739\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-with-PARTITION-BY-clause-example.png 513w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-with-PARTITION-BY-clause-example-300x180.png 300w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/><\/figure>\n\n\n\n<p>In this example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the <code>PARTITION BY<\/code> clause distributed the tracks into albums.<\/li>\n\n\n\n<li>Then, the <code>ORDER BY<\/code> clause sorted the tracks in each album by their lengths.<\/li>\n\n\n\n<li>Finally, the <code>DENSE_RANK()<\/code> function applied to each partition separately to compute the rank for the track in the partition.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the SQLite <code>DENSE_RANK()<\/code> function to compute the rank of a row in an ordered set of rows.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"1737\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\"\n\t\t\t\tdata-post-title=\"SQLite DENSE_RANK() Function\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"1737\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\"\n\t\t\t\tdata-post-title=\"SQLite DENSE_RANK() Function\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1659,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1737","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQLite DENSE_RANK() Function<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.\" \/>\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.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite DENSE_RANK() Function\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLite Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-16T02:52:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\"},\"headline\":\"SQLite DENSE_RANK() Function\",\"datePublished\":\"2018-11-11T09:16:47+00:00\",\"dateModified\":\"2024-04-16T02:52:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\"},\"wordCount\":337,\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\",\"url\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\",\"name\":\"SQLite DENSE_RANK() Function\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\",\"datePublished\":\"2018-11-11T09:16:47+00:00\",\"dateModified\":\"2024-04-16T02:52:53+00:00\",\"description\":\"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage\",\"url\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\",\"contentUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png\",\"width\":120,\"height\":163,\"caption\":\"SQLite DENSE_RANK Function example\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlitetutorial.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite Window Functions\",\"item\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQLite DENSE_RANK() Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\",\"url\":\"https:\/\/www.sqlitetutorial.net\/\",\"name\":\"SQLite Tutorial\",\"description\":\"A Step-by-step SQLite Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlitetutorial.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\",\"name\":\"admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLite DENSE_RANK() Function","description":"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.","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.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/","og_locale":"en_US","og_type":"article","og_title":"SQLite DENSE_RANK() Function","og_description":"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.","og_url":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/","og_site_name":"SQLite Tutorial","article_modified_time":"2024-04-16T02:52:53+00:00","og_image":[{"url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#article","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/"},"author":{"name":"admin","@id":"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427"},"headline":"SQLite DENSE_RANK() Function","datePublished":"2018-11-11T09:16:47+00:00","dateModified":"2024-04-16T02:52:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/"},"wordCount":337,"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/","url":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/","name":"SQLite DENSE_RANK() Function","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png","datePublished":"2018-11-11T09:16:47+00:00","dateModified":"2024-04-16T02:52:53+00:00","description":"This tutorial shows you how to use the SQLite DENSE_RANK() function to compute the rank of a row in an ordered set of rows.","breadcrumb":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#primaryimage","url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png","contentUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-DENSE_RANK-Function-example.png","width":120,"height":163,"caption":"SQLite DENSE_RANK Function example"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-dense_rank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlitetutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQLite Window Functions","item":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/"},{"@type":"ListItem","position":3,"name":"SQLite DENSE_RANK() Function"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlitetutorial.net\/#website","url":"https:\/\/www.sqlitetutorial.net\/","name":"SQLite Tutorial","description":"A Step-by-step SQLite Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlitetutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427","name":"admin"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/comments?post=1737"}],"version-history":[{"count":2,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1737\/revisions"}],"predecessor-version":[{"id":3173,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1737\/revisions\/3173"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1659"}],"wp:attachment":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/media?parent=1737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}