{"id":945,"date":"2026-06-05T18:19:29","date_gmt":"2026-06-05T21:19:29","guid":{"rendered":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/"},"modified":"2026-06-05T18:19:29","modified_gmt":"2026-06-05T21:19:29","slug":"aula-12-window-functions-rank-rownumber-lag-e-lead","status":"publish","type":"post","link":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/","title":{"rendered":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD"},"content":{"rendered":"<p>Nesta aula, vamos explorar as fascinantes <strong>Window Functions<\/strong> do PostgreSQL, com foco nas fun\u00e7\u00f5es <strong>RANK<\/strong>, <strong>ROW_NUMBER<\/strong>, <strong>LAG<\/strong> e <strong>LEAD<\/strong>. Estas fun\u00e7\u00f5es s\u00e3o cruciais para realizar an\u00e1lises complexas e manipular conjuntos de dados de forma eficiente. Compreender e saber utilizar as <strong>Window Functions<\/strong> lhe permitir\u00e1 criar consultas mais poderosas, otimizando relat\u00f3rios e an\u00e1lises.<\/p>\n<h3>O que voc\u00ea vai aprender nesta aula<\/h3>\n<ul>\n<li>O que s\u00e3o Window Functions e como elas diferem de fun\u00e7\u00f5es agregadas comuns.<\/li>\n<li>Utilizar as fun\u00e7\u00f5es RANK e ROW_NUMBER para ordenar dados.<\/li>\n<li>Como usar LAG e LEAD para acessar linhas anteriores ou posteriores em um conjunto de dados.<\/li>\n<li>Implementa\u00e7\u00e3o pr\u00e1tica de cada fun\u00e7\u00e3o em consultas SQL reais.<\/li>\n<\/ul>\n<h3>Entendendo as Window Functions<\/h3>\n<p>As <strong>Window Functions<\/strong> s\u00e3o uma caracter\u00edstica avan\u00e7ada do PostgreSQL que permite realizar c\u00e1lculos em um conjunto de linhas relacionadas ao valor atual sem agregar os resultados em uma \u00fanica linha. Diferentemente das fun\u00e7\u00f5es agregadas, que &#8220;colapsam&#8221; dados, as fun\u00e7\u00f5es janela preservam as linhas originais e aplicam fun\u00e7\u00f5es como soma cumulativa, m\u00e9dia m\u00f3vel e, claro, ranking.<\/p>\n<h3>RANK e ROW_NUMBER: Ordenando seus dados<\/h3>\n<p>Tanto o <strong>RANK<\/strong> quanto o <strong>ROW_NUMBER<\/strong> s\u00e3o Window Functions utilizadas para gerar n\u00fameros de classifica\u00e7\u00e3o sobre parti\u00e7\u00f5es de dados.<\/p>\n<pre><code>\nSELECT nome, departamento, salario,\n       RANK() OVER (PARTITION BY departamento ORDER BY salario DESC) AS rank,\n       ROW_NUMBER() OVER (PARTITION BY departamento ORDER BY salario DESC) AS row_number\nFROM empregados;\n<\/code><\/pre>\n<p>No exemplo acima, estamos classificando empregados por sal\u00e1rio dentro de cada departamento. <strong>RANK<\/strong> atribui o mesmo valor \u00e0s linhas que t\u00eam o mesmo ranking, enquanto <strong>ROW_NUMBER<\/strong> atribui n\u00fameros \u00fanicos e sequenciais \u00e0s linhas.<\/p>\n<h3>LAG e LEAD: Acessando linhas vizinhas<\/h3>\n<p>As fun\u00e7\u00f5es <strong>LAG<\/strong> e <strong>LEAD<\/strong> s\u00e3o extremamente poderosas quando precisamos acessar os valores de linhas anteriores ou posteriores dentro de um conjunto de dados.<\/p>\n<pre><code>\nSELECT nome, salario,\n       LAG(salario, 1) OVER (ORDER BY salario) AS salario_anterior,\n       LEAD(salario, 1) OVER (ORDER BY salario) AS salario_proximo\nFROM empregados;\n<\/code><\/pre>\n<p>No exemplo, <strong>LAG<\/strong> retorna o sal\u00e1rio da linha anterior e <strong>LEAD<\/strong> retorna o sal\u00e1rio da pr\u00f3xima linha quando ordenados por sal\u00e1rio. Isso \u00e9 particularmente \u00fatil para calcular diferen\u00e7as entre linhas consecutivas, como varia\u00e7\u00f5es de sal\u00e1rio ou m\u00e9tricas de performance.<\/p>\n<h3>Aplica\u00e7\u00f5es Pr\u00e1ticas de Window Functions<\/h3>\n<p>Em nossos projetos na <strong>JRT Technology Solutions<\/strong>, frequentemente usamos <strong>Window Functions<\/strong> para an\u00e1lises detalhadas de dados. Elas s\u00e3o usadas para c\u00e1lculos como:<\/p>\n<ul>\n<li>Analytics sobre vendas e compara\u00e7\u00f5es intertemporais.<\/li>\n<li>Avalia\u00e7\u00e3o de desempenho ao longo do tempo.<\/li>\n<li>Gerar relat\u00f3rios detalhados sem a necessidade de subconsultas complexas.<\/li>\n<\/ul>\n<p>Os nossos especialistas utilizam diariamente essas pr\u00e1ticas para otimizar processos e relat\u00f3rios de clientes.<\/p>\n<h3>Resumo da Aula 12<\/h3>\n<p>Nesta aula, voc\u00ea aprendeu a import\u00e2ncia e a aplica\u00e7\u00e3o das <strong>Window Functions<\/strong> no PostgreSQL. Exploramos as fun\u00e7\u00f5es <strong>RANK<\/strong>, <strong>ROW_NUMBER<\/strong>, <strong>LAG<\/strong> e <strong>LEAD<\/strong> para manipular dados de forma eficaz. Na pr\u00f3xima aula, vamos aprofundar nosso conhecimento explorando a fun\u00e7\u00e3o <strong>NTILE<\/strong> e seus usos em segmenta\u00e7\u00e3o de dados. Fique atento para continuar avan\u00e7ando em seu dom\u00ednio sobre PostgreSQL!<\/p>\n<div style=\"margin:48px 0 32px;padding:32px 24px;background:#f0fdf4;border:1px solid #bbf7d0;border-radius:16px;text-align:center;\">\n<p style=\"margin:0 0 8px;font-size:17px;color:#111827;font-weight:700;\">Quer aprender na pr\u00e1tica com especialistas?<\/p>\n<p style=\"margin:0 0 24px;font-size:15px;color:#1f2937;font-weight:400;\">A JRT Technology Solutions oferece treinamentos e implementa\u00e7\u00e3o de PostgreSQL para equipes corporativas.<\/p>\n<p>  <a href=\"https:\/\/api.whatsapp.com\/send\/?phone=5521980606699&#038;text=Ol%C3%A1%21+Tenho+interesse+no+treinamento+de+PostgreSQL.&#038;type=phone_number&#038;app_absent=0\"\n     target=\"_blank\" rel=\"noopener noreferrer\"\n     style=\"display:inline-flex;align-items:center;gap:12px;background:#25D366;color:#ffffff;font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;font-size:16px;font-weight:600;padding:14px 28px;border-radius:100px;text-decoration:none;box-shadow:0 4px 12px rgba(37,211,102,0.4);letter-spacing:0.01em;\"><br \/>\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"22\" height=\"22\" viewBox=\"0 0 24 24\" fill=\"#ffffff\">\n      <path d=\"M17.472 14.382c-.297-.149-1.758-.867-2.03-.967-.273-.099-.471-.148-.67.15-.197.297-.767.966-.94 1.164-.173.199-.347.223-.644.075-.297-.15-1.255-.463-2.39-1.475-.883-.788-1.48-1.761-1.653-2.059-.173-.297-.018-.458.13-.606.134-.133.298-.347.446-.52.149-.174.198-.298.298-.497.099-.198.05-.371-.025-.52-.075-.149-.669-1.612-.916-2.207-.242-.579-.487-.5-.669-.51-.173-.008-.371-.01-.57-.01-.198 0-.52.074-.792.372-.272.297-1.04 1.016-1.04 2.479 0 1.462 1.065 2.875 1.213 3.074.149.198 2.096 3.2 5.077 4.487.709.306 1.262.489 1.694.625.712.227 1.36.195 1.871.118.571-.085 1.758-.719 2.006-1.413.248-.694.248-1.289.173-1.413-.074-.124-.272-.198-.57-.347m-5.421 7.403h-.004a9.87 9.87 0 01-5.031-1.378l-.361-.214-3.741.982.998-3.648-.235-.374a9.86 9.86 0 01-1.51-5.26c.001-5.45 4.436-9.884 9.888-9.884 2.64 0 5.122 1.03 6.988 2.898a9.825 9.825 0 012.893 6.994c-.003 5.45-4.437 9.884-9.885 9.884m8.413-18.297A11.815 11.815 0 0012.05 0C5.495 0 .16 5.335.157 11.892c0 2.096.547 4.142 1.588 5.945L.057 24l6.305-1.654a11.882 11.882 0 005.683 1.448h.005c6.554 0 11.89-5.335 11.893-11.893a11.821 11.821 0 00-3.48-8.413z\"\/>\n    <\/svg><br \/>\n    Falar no WhatsApp<br \/>\n  <\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!<\/p>\n","protected":false},"author":1,"featured_media":944,"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,"iawp_total_views":0,"footnotes":""},"categories":[75],"tags":[1646,1644,1645,1642,1643,1641],"class_list":["post-945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops","tag-funcoes-de-janela-sql","tag-lag-sql","tag-lead-sql","tag-rank-sql","tag-row_number-sql","tag-window-functions"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Thiago Paes Rodrigues\"\/>\n\t<meta name=\"google-site-verification\" content=\"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta property=\"og:description\" content=\"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"100\" \/>\n\t\t<meta property=\"og:image:height\" content=\"75\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-06-05T21:19:29+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-06-05T21:19:29+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=61590814880509\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#blogposting\",\"name\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions\",\"headline\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD\",\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/ai-image-1780694361841.jpg\",\"width\":1536,\"height\":1024,\"caption\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD\"},\"datePublished\":\"2026-06-05T18:19:29-03:00\",\"dateModified\":\"2026-06-05T18:19:29-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#webpage\"},\"articleSection\":\"DevOps, fun\\u00e7\\u00f5es de janela SQL, LAG SQL, LEAD SQL, RANK SQL, ROW_NUMBER SQL, window functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"position\":2,\"name\":\"DevOps\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#listItem\",\"name\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#listItem\",\"position\":3,\"name\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"telephone\":\"+552138277513\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-logo-mini.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#organizationLogo\",\"width\":100,\"height\":75},\"image\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=61590814880509\",\"https:\\\/\\\/www.instagram.com\\\/jrtx.tech\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/\",\"name\":\"Thiago Paes Rodrigues\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Thiago Paes Rodrigues\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#webpage\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/\",\"name\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions\",\"description\":\"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/ai-image-1780694361841.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#mainImage\",\"width\":1536,\"height\":1024,\"caption\":\"Aula 12: Window Functions \\u2014 RANK, ROW_NUMBER, LAG e LEAD\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/05\\\/aula-12-window-functions-rank-rownumber-lag-e-lead\\\/#mainImage\"},\"datePublished\":\"2026-06-05T18:19:29-03:00\",\"dateModified\":\"2026-06-05T18:19:29-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"alternateName\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions","description":"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!","canonical_url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#blogposting","name":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions","headline":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD","author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/06\/ai-image-1780694361841.jpg","width":1536,"height":1024,"caption":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD"},"datePublished":"2026-06-05T18:19:29-03:00","dateModified":"2026-06-05T18:19:29-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#webpage"},"isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#webpage"},"articleSection":"DevOps, fun\u00e7\u00f5es de janela SQL, LAG SQL, LEAD SQL, RANK SQL, ROW_NUMBER SQL, window functions"},{"@type":"BreadcrumbList","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","position":1,"name":"Home","item":"https:\/\/jrtx.com.br\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","position":2,"name":"DevOps","item":"https:\/\/jrtx.com.br\/blog\/category\/devops\/","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#listItem","name":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#listItem","position":3,"name":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD","previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}}]},{"@type":"Organization","@id":"https:\/\/jrtx.com.br\/blog\/#organization","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","url":"https:\/\/jrtx.com.br\/blog\/","telephone":"+552138277513","logo":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#organizationLogo","width":100,"height":75},"image":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=61590814880509","https:\/\/www.instagram.com\/jrtx.tech\/"]},{"@type":"Person","@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author","url":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/","name":"Thiago Paes Rodrigues","image":{"@type":"ImageObject","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g","width":96,"height":96,"caption":"Thiago Paes Rodrigues"}},{"@type":"WebPage","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#webpage","url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/","name":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions","description":"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#breadcrumblist"},"author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"creator":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/06\/ai-image-1780694361841.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#mainImage","width":1536,"height":1024,"caption":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD"},"primaryImageOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/#mainImage"},"datePublished":"2026-06-05T18:19:29-03:00","dateModified":"2026-06-05T18:19:29-03:00"},{"@type":"WebSite","@id":"https:\/\/jrtx.com.br\/blog\/#website","url":"https:\/\/jrtx.com.br\/blog\/","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","alternateName":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","og:type":"article","og:title":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions","og:description":"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!","og:url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/","og:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:secure_url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:width":100,"og:image:height":75,"article:published_time":"2026-06-05T21:19:29+00:00","article:modified_time":"2026-06-05T21:19:29+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=61590814880509","twitter:card":"summary_large_image","twitter:title":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD - BLOG - JRT Technology Solutions","twitter:description":"Aprenda com a Aula 12 sobre Window Functions: RANK, ROW_NUMBER, LAG e LEAD. Otimize suas consultas SQL e descubra novas possibilidades!","twitter:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg"},"aioseo_meta_data":{"post_id":"945","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-22 19:18:50","updated":"2026-06-22 19:18:50"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\/category\/devops\/\" title=\"DevOps\">DevOps<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tAula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/jrtx.com.br\/blog"},{"label":"DevOps","link":"https:\/\/jrtx.com.br\/blog\/category\/devops\/"},{"label":"Aula 12: Window Functions \u2014 RANK, ROW_NUMBER, LAG e LEAD","link":"https:\/\/jrtx.com.br\/blog\/2026\/06\/05\/aula-12-window-functions-rank-rownumber-lag-e-lead\/"}],"_links":{"self":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/comments?post=945"}],"version-history":[{"count":0,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/945\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media?parent=945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/categories?post=945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/tags?post=945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}