{"id":8374,"date":"2021-02-03T07:05:00","date_gmt":"2021-02-03T07:05:00","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=8374"},"modified":"2026-02-16T04:57:10","modified_gmt":"2026-02-16T04:57:10","slug":"how-to-get-row_number-in-mysql","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/","title":{"rendered":"How To Get row_number in MySQL"},"content":{"rendered":"\n<p>Sometimes you may need to get row number in MySQL for reporting and analysis. Row number is very useful in ranking and sorting data. It is also helpful in assigning row numbers to each row, filtering data based on row number value, <a href=\"https:\/\/ubiq.co\/tech-blog\/mysql-remove-duplicate-records\/\">removing duplicates<\/a>, pagination of query results and more. In this article, we will look at how to get <em>row_number<\/em> in MySQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#How_To_Get_row_number_in_MySQL\" >How To Get row_number in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#1_Using_ROW_NUMBER\" >1. Using ROW_NUMBER()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#2_Using_Variable\" >2. Using Variable<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_To_Get_row_number_in_MySQL\"><\/span>How To Get row_number in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>MySQL 8+ features row_number() function which is useful in retrieving row numbers for query results. For MySQL older than 8.0, you need to use session variables to assign row numbers. In this article, we will look at both these solutions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Using_ROW_NUMBER\"><\/span>1. Using ROW_NUMBER()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Row_number() function is available out of the box since MySQL 8.0. It is a window function, that allows you to perform some operations across all rows on a table, in relation to the current row. You can use it to assign row number starting 1 for the first row to the last row in the table. You can also partition your table into groups of rows and use row_number() function to separately number rows of each partition.<\/p>\n\n\n\n<p>Here is the syntax of <em>row_number()<\/em> syntax. Please note, the PARTITION BY clause is optional.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ROW_NUMBER() OVER (\n     PARTITION BY &lt;expression(s)&gt; \n     ORDER BY &lt;expression(s)&gt; [ASC|DESC])<\/pre>\n\n\n\n<p>Let us say you have the following <em>sales<\/em> table.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> +------+------------+--------+\n | id   | order_date | amount |\n +------+------------+--------+\n |    1 | 2021-01-01 |    200 |\n |    2 | 2021-01-02 |    250 |\n |    3 | 2021-01-03 |    220 |\n |    4 | 2021-01-04 |    230 |\n |    5 | 2021-01-05 |    210 |\n |    6 | 2021-01-06 |    100 |\n |    7 | 2021-01-07 |    120 |\n |    8 | 2021-01-08 |    150 |\n |    9 | 2021-01-09 |    180 |\n |   10 | 2021-01-10 |    200 |\n +------+------------+--------+<\/pre>\n\n\n\n<p>Here is an example of using <em>row_number<\/em> function to rank rows in descending order of <em>amount<\/em> column. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; select row_number() over (\n       order by amount desc) row_num,\n       amount\n       from sales\n       order by amount desc;\n +---------+--------+\n | row_num | amount |\n +---------+--------+\n |       1 |    250 |\n |       2 |    230 |\n |       3 |    220 |\n |       4 |    210 |\n |       5 |    200 |\n |       6 |    200 |\n |       7 |    180 |\n |       8 |    150 |\n |       9 |    120 |\n |      10 |    100 |\n +---------+--------+<\/pre>\n\n\n\n<p>In the above query, we treat the entire table as a single partition and don&#8217;t provide PARTITION BY clause. We also order these rows in descending order by amount column and use <em>row_number()<\/em> function to rank these rows.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Using_Variable\"><\/span>2. Using Variable<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>However, if you are using MySQL &lt;8.0 then here are the steps to get <em>row_number<\/em> in MySQL.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; SELECT t.*, @rownum := @rownum + 1 AS rank \n          FROM sales t, (SELECT @rownum := 0) r  \n          order by amount desc;\n +------+---------------------+--------+------+\n | id   | order_date          | amount | rank |\n +------+---------------------+--------+------+\n |    1 | 2021-02-02 08:15:00 |    250 |    1 |\n |   10 | 2021-02-02 11:15:00 |    250 |    2 |\n |    5 | 2021-02-02 09:30:00 |    250 |    3 |\n |    9 | 2021-02-02 10:45:00 |    200 |    4 |\n |   12 | 2021-02-02 11:45:00 |    200 |    5 |\n |    6 | 2021-02-02 09:45:00 |    200 |    6 |\n |    2 | 2021-02-02 08:30:00 |    200 |    7 |\n |    7 | 2021-02-02 10:15:00 |    180 |    8 |\n |    3 | 2021-02-02 08:55:00 |    150 |    9 |\n |   11 | 2021-02-02 11:30:00 |    150 |   10 |\n |    4 | 2021-02-02 09:15:00 |    125 |   11 |\n |    8 | 2021-02-02 10:30:00 |    125 |   12 |\n +------+---------------------+--------+------+<\/pre>\n\n\n\n<p>In the above SQL query, we use a temporary variable <em>rownum<\/em> to store row number. rownum is set to 0. When MySQL sequentially traverses the rows, it assigns <em>rownum<\/em> to each row in an incremental manner.<\/p>\n\n\n\n<p>These solutions are often used to <a href=\"https:\/\/ubiq.co\/tech-blog\/mysql-select-top-n-rows-per-group\/\">select top N rows per group<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Very often database programmers and analysts need to use row numbers. By default, if you have an auto increment primary key without any gaps in its values, then you can directly use it to fetch data as per your requirement. But as your table undergoes insertion and deletions, the primary key will no longer be continuous. Therefore, it is better to separately generate row numbers for each row. If you are using MySQL &lt; 8.0, then you can use a session variable to save row numbers. MySQL 8+ provides row_number() that allows you to number all rows in a table as a single group or multiple partitions. Numbering of rows is required to pick top N rows from a table, filter N rows in each group, remove duplicates and paginate query results. You can customize them as per your requirement.<\/p>\n\n\n\n<p>Need a reporting tool for MySQL?&nbsp;<a href=\"http:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;makes it easy to visualize data in minutes, and monitor in real-time dashboards.&nbsp;<a href=\"http:\/\/ubiq.co\/accounts\/register\">Try it<\/a>&nbsp;Today!<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-data-for-every-hour-in-mysql\/\">How to Get Data for Every Hour in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-last-1-hour-data-in-mysql\/\">How to Get Last 1 Hour Data in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-show-rows-not-present-in-another-table-in-mysql\/\">How to Show Rows Not Present in Another Table<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.<\/p>\n","protected":false},"author":1,"featured_media":8375,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[436],"class_list":["post-8374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-row_number"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Get row_number in MySQL - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Get row_number in MySQL - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-03T07:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-16T04:57:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"730\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How To Get row_number in MySQL\",\"datePublished\":\"2021-02-03T07:05:00+00:00\",\"dateModified\":\"2026-02-16T04:57:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/\"},\"wordCount\":541,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/mysql-row-number.webp?fit=730%2C410&ssl=1\",\"keywords\":[\"row_number\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/\",\"name\":\"How To Get row_number in MySQL - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/mysql-row-number.webp?fit=730%2C410&ssl=1\",\"datePublished\":\"2021-02-03T07:05:00+00:00\",\"dateModified\":\"2026-02-16T04:57:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/mysql-row-number.webp?fit=730%2C410&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/mysql-row-number.webp?fit=730%2C410&ssl=1\",\"width\":730,\"height\":410,\"caption\":\"mysql row number\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-get-row_number-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Get row_number in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Get row_number in MySQL - Ubiq BI","description":"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.","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:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How To Get row_number in MySQL - Ubiq BI","og_description":"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2021-02-03T07:05:00+00:00","article_modified_time":"2026-02-16T04:57:10+00:00","og_image":[{"width":730,"height":410,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp","type":"image\/webp"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How To Get row_number in MySQL","datePublished":"2021-02-03T07:05:00+00:00","dateModified":"2026-02-16T04:57:10+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/"},"wordCount":541,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp?fit=730%2C410&ssl=1","keywords":["row_number"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/","name":"How To Get row_number in MySQL - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp?fit=730%2C410&ssl=1","datePublished":"2021-02-03T07:05:00+00:00","dateModified":"2026-02-16T04:57:10+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Row number is very useful in ranking and sorting. Here is how to get row_number in MySQL.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp?fit=730%2C410&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp?fit=730%2C410&ssl=1","width":730,"height":410,"caption":"mysql row number"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-get-row_number-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How To Get row_number in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2025\/06\/mysql-row-number.webp?fit=730%2C410&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2b4","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=8374"}],"version-history":[{"count":4,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8374\/revisions"}],"predecessor-version":[{"id":10614,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8374\/revisions\/10614"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/8375"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=8374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=8374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=8374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}