{"id":10354,"date":"2019-03-11T19:28:43","date_gmt":"2019-03-11T19:28:43","guid":{"rendered":"https:\/\/dbtut.com\/?p=10354"},"modified":"2019-03-11T19:28:43","modified_gmt":"2019-03-11T19:28:43","slug":"ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/","title":{"rendered":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>These are the special sorting functions that we can use to sort the data that we select from the tables at run time.<\/p>\n<ul type=\"disc\">\n<li>ROW_NUMBER<\/li>\n<li>RANK<\/li>\n<li>DENSE_RANK<\/li>\n<li>NTILE<\/li>\n<\/ul>\n<p>First, create a table as follows and add a few records into it with the following script.<\/p>\n<pre class=\"lang:default decode:true \">CREATE TABLE [dbo].[MemberJobs](\n\t[MemberID] [int] NULL,\n\t[Job] [varchar](50) NULL,\n\t[City] [varchar](50) NULL,\n\t[MemberName] [varchar](50) NULL\n) ON [PRIMARY]\nGO\nINSERT INTO [dbo].[MemberJobs] ([MemberID],[Job],[City],[MemberName])\n     VALUES (3,'Engineer','\u0130stanbul','Ali'),\n\t\t\t(4,'Doctor','Ankara','Veli'),\n\t\t\t(5,'Engineer','Adana','Ahmet'),\n\t\t\t(6,'Doctor','Adana','Mehmet'),\n\t\t\t(7,'Trainer','\u0130stanbul','Ay\u015fe'),\n\t\t\t(8,'Doctor','\u0130stanbul','Ali'),\n\t\t\t(9,'Doctor','\u0130stanbul','Veli'),\n\t\t\t(10,'Engineer','Adana','Ali')\nGO\nSELECT * FROM [dbo].[MemberJobs]\n<\/pre>\n<p id=\"gyDlldz\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-10356  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\" alt=\"\" width=\"770\" height=\"648\"><\/p>\n<h3 style=\"margin: 0in;font-family: Georgia;font-size: 12.0pt\">ROW_NUMBER<\/h3>\n<p>This function sequentialy numbers each row starting from 1 according to the sort expression.<\/p>\n<pre class=\"lang:default decode:true\">ROW_NUMBER() OVER ([ ] )<\/pre>\n<p>Number the output by sorting the City and MemberId columns.<\/p>\n<pre class=\"lang:default decode:true \">SELECT ROW_NUMBER() OVER(ORDER BY City) City_Order,\n* FROM [dbo].[MemberJobs]\nORDER BY City, MemberId<\/pre>\n<p id=\"SnoDWSc\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-10358  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8626a9e44af.png\" alt=\"\" width=\"724\" height=\"362\"><\/p>\n<p>We can sort the different data in a column separately.&nbsp; Let&#8217;s sort the cities depending on the Job column according to the values \u200b\u200bin the example.<\/p>\n<pre class=\"lang:default decode:true \">SELECT ROW_NUMBER() OVER(ORDER BY City) City_Order,\nROW_NUMBER() OVER(PARTITION BY Job ORDER BY City) as City_Order_Depending_Jobs,\n* FROM [dbo].[MemberJobs] ORDER BY City, MemberID\n<\/pre>\n<p id=\"jsrbgsV\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-10360  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8626ea667b3.png\" alt=\"\" width=\"733\" height=\"311\"><\/p>\n<h3>RANK and DENSE_RANK Functions:<\/h3>\n<p>The RANK () and DENSE_RANK () functions group data according to a column and sort the groups by assigning a number to each group.<\/p>\n<p><strong>The difference between RANK and DENSE_RANK functions:<\/strong><\/p>\n<p>In the RANK () function; While the value of the first group is 1, and the value of the second group is not always 2. If there are 3 values \u200b\u200bin the first group, the value of the second group is 4. In the DENSE_RANK () function, the group numbers are consecutive. No matter how many records in the first group, the value of the second group is always 2. In the following example, this topic is very clear.<\/p>\n<pre class=\"lang:default decode:true \">SELECT RANK() OVER(ORDER BY City) RANK,\nDENSE_RANK() OVER(ORDER BY City) as DENSE_RANK,\n* FROM [dbo].[MemberJobs] ORDER BY City, MemberID\n<\/pre>\n<p id=\"AJBqyLf\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-10362  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c86271c7f756.png\" alt=\"\" width=\"656\" height=\"418\"><\/p>\n<h3>NTILE Function:<\/h3>\n<p>NTILE () will sort the dataset according to the columns specified by OVER and ORDER BY. And groups the records by the number specified in the parameter, and&nbsp; gives each group a sequential number.<\/p>\n<p>The integer_expression parameter is a positive integer indicating the number of groups. Suppose that 30 records are returned as a result of the query and the parameter value specified in the NTILE () function is 5. In this case, 5 groups of 6 rows are created. And each group is given sequential numbers, starting from 1. That is, the number of the first 6 records is set to 1, the number of the next 6 records is 2, and the number of the last 6 records is set to 5.<\/p>\n<p>There are 8 records in our example, let&#8217;s try NTILE with different values.<\/p>\n<pre class=\"lang:default decode:true \">SELECT\nNTILE(2) OVER(ORDER BY City) [NTILE2],\nNTILE(3) OVER(ORDER BY City) [NTILE3],\nNTILE(4) OVER(ORDER BY City) [NTILE4],\nNTILE(5) OVER(ORDER BY City) [NTILE5], *\nFROM [dbo].[MemberJobs] ORDER BY City\n<\/pre>\n<p id=\"BMIOjeW\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-10364  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c86274dce846.png\" alt=\"\" width=\"682\" height=\"406\"><\/p>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_10354\" class=\"pvc_stats all  \" data-element-id=\"10354\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; These are the special sorting functions that we can use to sort the data that we select from the tables at run time. ROW_NUMBER RANK DENSE_RANK NTILE First, create a table as follows and add a few records into it with the following script. CREATE TABLE [dbo].[MemberJobs]( [MemberID] [int] NULL, [Job] [varchar](50) NULL, [City] &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_10354\" class=\"pvc_stats all  \" data-element-id=\"10354\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":470,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[2486,2490,2487,2491,2485,2489,2484,2488],"class_list":["post-10354","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-dense_rank","tag-dense_rank-function","tag-ntile","tag-ntile-function","tag-rank","tag-rank-function","tag-row_number","tag-row_number-function"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":547,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-11T19:28:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\" \/>\n<meta name=\"author\" content=\"Ahmet KAYMAZ\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmet KAYMAZ\" \/>\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:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\"},\"author\":{\"name\":\"Ahmet KAYMAZ\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad\"},\"headline\":\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)\",\"datePublished\":\"2019-03-11T19:28:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\"},\"wordCount\":348,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\",\"keywords\":[\"DENSE_RANK\",\"DENSE_RANK Function\",\"NTILE\",\"NTILE Function\",\"RANK\",\"RANK Function\",\"ROW_NUMBER\",\"ROW_NUMBER Function\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\",\"name\":\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\",\"datePublished\":\"2019-03-11T19:28:43+00:00\",\"description\":\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png\",\"width\":950,\"height\":800},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad\",\"name\":\"Ahmet KAYMAZ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g\",\"caption\":\"Ahmet KAYMAZ\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ahmetkaymaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials","description":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)","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:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials","og_description":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-11T19:28:43+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png","type":"","width":"","height":""}],"author":"Ahmet KAYMAZ","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ahmet KAYMAZ","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/"},"author":{"name":"Ahmet KAYMAZ","@id":"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad"},"headline":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)","datePublished":"2019-03-11T19:28:43+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png","keywords":["DENSE_RANK","DENSE_RANK Function","NTILE","NTILE Function","RANK","RANK Function","ROW_NUMBER","ROW_NUMBER Function"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/","name":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png","datePublished":"2019-03-11T19:28:43+00:00","description":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c862669afba1.png","width":950,"height":800},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/11\/ranking-functionsrow_number-rank-dense_rank-ntile-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Ranking Functions(ROW_NUMBER, RANK, DENSE_RANK, NTILE) in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad","name":"Ahmet KAYMAZ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g","caption":"Ahmet KAYMAZ"},"url":"https:\/\/dbtut.com\/index.php\/author\/ahmetkaymaz\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/470"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=10354"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10354\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=10354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=10354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=10354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}