{"id":1661,"date":"2018-11-04T18:20:50","date_gmt":"2018-11-04T11:20:50","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=1661"},"modified":"2024-04-16T10:18:54","modified_gmt":"2024-04-16T03:18:54","slug":"sqlite-row_number","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/","title":{"rendered":"SQLite ROW_NUMBER() Function"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the SQLite <code>ROW_NUMBER()<\/code> function to assign a sequential integer to each row in the result set of a query.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to SQLite ROW_NUMBER() function<\/h2>\n\n\n\n<p>The <code>ROW_NUMBER()<\/code> is a window function that assigns a sequential integer to each row of a query&#8217;s result set. Rows are ordered starting from one based on the order specified by the <code>ORDER BY<\/code> clause in the window definition.<\/p>\n\n\n\n<p>The following shows the syntax of the <code>ROW_NUMBER()<\/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\">ROW_NUMBER() OVER (\n    &#91;PARTITION BY expression1, expression2,...]\n    ORDER BY expression1 &#91;ASC | DESC], expression2,...\n)\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>First, the <code>PARTITION BY<\/code> clause divides the rows derived from the <code>FROM<\/code> clause into partitions. The <code>PARTITION BY<\/code> clause is optional. If you skip it, the <code>ROW_NUMBER()<\/code> will treat the whole result set as a single partition.<\/li>\n\n\n\n<li>Then, the <code>ORDER BY<\/code> clause specifies the order of the rows in each partition. The <code>ORDER BY<\/code> clause is mandatory because the <code>ROW_NUMBER()<\/code> function is order sensitive.<\/li>\n\n\n\n<li>Finally, each row in each partition is assigned a sequential integer number called a row number. The row number is reset for each partition.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">SQLite ROW_NUMBER() function examples<\/h2>\n\n\n\n<p>We will use the <code>customers<\/code>&nbsp;and <code>invoices<\/code> tables from the <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-sample-database\/\">sample database<\/a> for the demonstration.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"304\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png\" alt=\"\" class=\"wp-image-1579\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png 384w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices-300x238.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">1) Using SQLite ROW_NUMBER()\u00a0with ORDER BY clause example<\/h3>\n\n\n\n<p>The following statement returns the first name, last name, and country of all customers. In addition, it uses the <code>ROW_NUMBER()<\/code> function to add a sequential integer to each customer record.<\/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\">SELECT<\/span>\n    ROW_NUMBER () <span class=\"hljs-keyword\">OVER<\/span> ( \n        <span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> Country \n    ) <span class=\"hljs-keyword\">RowNum<\/span>,\n    FirstName,\n    LastName,\n    country \n<span class=\"hljs-keyword\">FROM<\/span>\n    customers;\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>Here is the partial output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"365\" height=\"301\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-ORDER-BY-example.png\" alt=\"SQLite ROW_NUMBER with ORDER BY example\" class=\"wp-image-1664\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-ORDER-BY-example.png 365w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-ORDER-BY-example-300x247.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2) Using the ROW_NUMBER() with PARTITION BY example<\/h3>\n\n\n\n<p>The following statement assigns a sequential integer to each customer and resets the number when the country of the customer changes:<\/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\">SELECT<\/span>\n    ROW_NUMBER () <span class=\"hljs-keyword\">OVER<\/span> ( \n        <span class=\"hljs-keyword\">PARTITION<\/span> <span class=\"hljs-keyword\">BY<\/span> Country\n        <span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> FirstName\n    ) <span class=\"hljs-keyword\">RowNum<\/span>,\n    FirstName,\n    LastName,\n    country \n<span class=\"hljs-keyword\">FROM<\/span>\n    customers;\n<\/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>The following picture shows the partial output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"339\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-PARTITION-BY-example.png\" alt=\"SQLite ROW_NUMBER with PARTITION BY example\" class=\"wp-image-1665\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-PARTITION-BY-example.png 367w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-with-PARTITION-BY-example-300x277.png 300w\" sizes=\"auto, (max-width: 367px) 100vw, 367px\" \/><\/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 divides the rows in the <code>customers<\/code> table into partitions by country.<\/li>\n\n\n\n<li>Second, the <code>ORDER BY<\/code> clause sorts rows in each partition by the first name.<\/li>\n\n\n\n<li>Third, the <code>ROW_NUMBER()<\/code> function assigns each row in each partition a sequential integer and resets the number when the country changes.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3) Using the ROW_NUMBER() function for pagination<\/h3>\n\n\n\n<p>The <code>ROW_NUMBER()<\/code> function can be useful for pagination. For example, if you want to display customer information on a table by pages with 10 rows per page.<\/p>\n\n\n\n<p>The following statement returns customer data from rows 21 to 30, which is the third page with 10 rows per page:<\/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  *\n<span class=\"hljs-keyword\">FROM<\/span>\n  (\n    <span class=\"hljs-keyword\">SELECT<\/span>\n      ROW_NUMBER() <span class=\"hljs-keyword\">OVER<\/span> (\n        <span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span>\n          FirstName\n      ) <span class=\"hljs-keyword\">RowNum<\/span>,\n      FirstName,\n      LastName,\n      Country\n    <span class=\"hljs-keyword\">FROM<\/span>\n      customers\n  ) t\n<span class=\"hljs-keyword\">WHERE<\/span>\n  <span class=\"hljs-keyword\">RowNum<\/span> &gt; <span class=\"hljs-number\">20<\/span>\n  <span class=\"hljs-keyword\">AND<\/span> <span class=\"hljs-keyword\">RowNum<\/span> &lt;= <span class=\"hljs-number\">30<\/span><\/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=\"383\" height=\"222\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-Pagination-example.png\" alt=\"SQLite ROW_NUMBER Pagination example\" class=\"wp-image-1666\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-Pagination-example.png 383w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-Pagination-example-300x174.png 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/figure>\n\n\n\n<p>In this example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the <code>ROW_NUMBER()<\/code> function assigns each row a sequential integer.<\/li>\n\n\n\n<li>Second, the outer query selects the row from 20 to 30.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">4) Using the ROW_NUMBER() to find the nth highest value per group<\/h3>\n\n\n\n<p>The following statement <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-create-view\/\">creates a new view<\/a> named <code>Sales<\/code> that consists of customer id, first name, last name, country, and amount. The amount&nbsp;is retrieved from the <code>invoices<\/code> table:<\/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\">CREATE<\/span> <span class=\"hljs-keyword\">VIEW<\/span> Sales \n<span class=\"hljs-keyword\">AS<\/span>\n<span class=\"hljs-keyword\">SELECT<\/span>\n    CustomerId,\n    FirstName,\n    LastName,\n    Country,\n    <span class=\"hljs-keyword\">SUM<\/span>( total ) Amount \n<span class=\"hljs-keyword\">FROM<\/span>\n    invoices \n    <span class=\"hljs-keyword\">INNER<\/span> <span class=\"hljs-keyword\">JOIN<\/span> customers <span class=\"hljs-keyword\">USING<\/span> (CustomerId)\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span>\n    CustomerId;\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 query returns the data from the <code>Sales<\/code> view:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" 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> * <span class=\"hljs-keyword\">FROM<\/span> sales;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><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<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"327\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-sales-view.png\" alt=\"SQLite ROW_NUMBER sales view\" class=\"wp-image-1667\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-sales-view.png 458w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-sales-view-300x214.png 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure>\n\n\n\n<p>The following statement finds the customers who have the highest amounts in each country:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" 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    Country,\n    FirstName,\n    LastName,\n    Amount\n<span class=\"hljs-keyword\">FROM<\/span> (\n    <span class=\"hljs-keyword\">SELECT<\/span> \n        Country, \n        FirstName,\n        LastName,\n        Amount,\n        ROW_NUMBER() <span class=\"hljs-keyword\">OVER<\/span> (\n            <span class=\"hljs-keyword\">PARTITION<\/span> <span class=\"hljs-keyword\">BY<\/span> country \n            <span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> Amount <span class=\"hljs-keyword\">DESC<\/span>\n        ) <span class=\"hljs-keyword\">RowNum<\/span>\n    <span class=\"hljs-keyword\">FROM<\/span> \n        Sales )\n<span class=\"hljs-keyword\">WHERE<\/span>\n    <span class=\"hljs-keyword\">RowNum<\/span> = <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><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 output is as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"378\" height=\"508\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-nth-highest-value-per-group-example.png\" alt=\"SQLite ROW_NUMBER nth highest value per group example\" class=\"wp-image-1668\" srcset=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-nth-highest-value-per-group-example.png 378w, https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/SQLite-ROW_NUMBER-nth-highest-value-per-group-example-223x300.png 223w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/figure>\n\n\n\n<p>In the <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-subquery\/\">subquery<\/a>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the <code>PARTITION BY<\/code> clause divides the customers by country.<\/li>\n\n\n\n<li>Second, the <code>ORDER BY<\/code> clause sorts the customers in each country by the amount from high to low.<\/li>\n\n\n\n<li>Third, the <code>ROW_NUMBER()<\/code> assigns each row a sequential integer. It resets the number when the country changes.<\/li>\n<\/ul>\n\n\n\n<p>The outer query selects the customers that have the <code>RowNum<\/code> with the value 1.<\/p>\n\n\n\n<p>If you change the row number in the WHERE clause to 2, 3, and so on, you will get the customers who have the second-highest amount, the third-highest amount, etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the <code>ROW_NUMBER()<\/code> function to assign a sequential integer to each row in the query&#8217;s result set.<\/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=\"1661\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\"\n\t\t\t\tdata-post-title=\"SQLite ROW_NUMBER() 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=\"1661\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\"\n\t\t\t\tdata-post-title=\"SQLite ROW_NUMBER() 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 ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1659,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1661","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 ROW_NUMBER() Function<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.\" \/>\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-row_number\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite ROW_NUMBER() Function\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLite Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-16T03:18:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.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=\"4 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-row_number\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\"},\"headline\":\"SQLite ROW_NUMBER() Function\",\"datePublished\":\"2018-11-04T11:20:50+00:00\",\"dateModified\":\"2024-04-16T03:18:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\"},\"wordCount\":551,\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\",\"url\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\",\"name\":\"SQLite ROW_NUMBER() Function\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png\",\"datePublished\":\"2018-11-04T11:20:50+00:00\",\"dateModified\":\"2024-04-16T03:18:54+00:00\",\"description\":\"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage\",\"url\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png\",\"contentUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png\",\"width\":384,\"height\":304},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#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 ROW_NUMBER() 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 ROW_NUMBER() Function","description":"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.","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-row_number\/","og_locale":"en_US","og_type":"article","og_title":"SQLite ROW_NUMBER() Function","og_description":"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.","og_url":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/","og_site_name":"SQLite Tutorial","article_modified_time":"2024-04-16T03:18:54+00:00","og_image":[{"url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#article","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/"},"author":{"name":"admin","@id":"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427"},"headline":"SQLite ROW_NUMBER() Function","datePublished":"2018-11-04T11:20:50+00:00","dateModified":"2024-04-16T03:18:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/"},"wordCount":551,"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/","url":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/","name":"SQLite ROW_NUMBER() Function","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png","datePublished":"2018-11-04T11:20:50+00:00","dateModified":"2024-04-16T03:18:54+00:00","description":"This tutorial shows you how to use the SQLite ROW_NUMBER() to assign a sequential integer to each row in the result set of a query.","breadcrumb":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#primaryimage","url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png","contentUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/customers_invoices.png","width":384,"height":304},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-window-functions\/sqlite-row_number\/#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 ROW_NUMBER() 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\/1661","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=1661"}],"version-history":[{"count":4,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1661\/revisions"}],"predecessor-version":[{"id":3192,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/1661\/revisions\/3192"}],"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=1661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}