{"id":1103,"date":"2026-06-16T18:01:42","date_gmt":"2026-06-16T21:01:42","guid":{"rendered":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/"},"modified":"2026-06-16T18:01:42","modified_gmt":"2026-06-16T21:01:42","slug":"aula-13-subqueries-e-ctes-with-clause-common-table-expressio","status":"publish","type":"post","link":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/","title":{"rendered":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)"},"content":{"rendered":"<p>Nesta aula, vamos explorar profundamente o uso de <strong>Subqueries e CTEs<\/strong> no contexto do Oracle SQL. Subconsultas e Common Table Expressions s\u00e3o componentes essenciais para a escrita de consultas complexas e otimiza\u00e7\u00e3o de c\u00f3digo. Iremos compreender os conceitos fundamentais, ver exemplos pr\u00e1ticos e aprender a aplicar t\u00e9cnicas que melhoram a performance e a legibilidade dos scripts SQL. Ao final, voc\u00ea ser\u00e1 capaz de criar consultas poderosas usando estas t\u00e9cnicas, habilidades extremamente valorizadas no mercado de TI.<\/p>\n<h3>O que voc\u00ea vai aprender nesta aula<\/h3>\n<ul>\n<li>Compreender o conceito e sintaxe de subqueries em Oracle SQL.<\/li>\n<li>Dominar o uso da cl\u00e1usula WITH para criar Common Table Expressions (CTEs).<\/li>\n<li>Aplicar subqueries e CTEs para otimiza\u00e7\u00e3o de consultas.<\/li>\n<li>Resolver problemas pr\u00e1ticos e complexos de consulta usando estas t\u00e9cnicas.<\/li>\n<li>Identificar e corrigir erros comuns associados ao uso de subqueries e CTEs.<\/li>\n<\/ul>\n<h3>Pr\u00e9-requisitos e Ambiente<\/h3>\n<p>Antes de iniciar, certifique-se de ter o Oracle Database instalado e configurado. Recomendamos o uso da vers\u00e3o 12c ou superior para garantir a compatibilidade com todos os exemplos fornecidos. Al\u00e9m disso, ter um conhecimento b\u00e1sico de SQL e ambiente SQL*Plus ou SQL Developer \u00e9 essencial.<\/p>\n<h3>Introdu\u00e7\u00e3o \u00e0s Subqueries<\/h3>\n<p>As <strong>subqueries<\/strong> s\u00e3o instru\u00e7\u00f5es SQL aninhadas dentro de outra consulta SQL. Elas s\u00e3o usadas para retornar dados que ser\u00e3o usados na consulta pai como condi\u00e7\u00e3o para restringir ou filtrar resultados. As subqueries podem ser inseridas em v\u00e1rias partes de uma consulta, como na cl\u00e1usula WHERE, FROM ou SELECT.<\/p>\n<h3>Exemplo de Subquery<\/h3>\n<p>Vamos considerar um exemplo pr\u00e1tico, onde precisamos encontrar o sal\u00e1rio m\u00e9dio de todos os departamentos e, em seguida, filtrar para os empregados cujo sal\u00e1rio \u00e9 superior a este valor m\u00e9dio.<\/p>\n<pre><code>SELECT employee_id, first_name, salary\nFROM employees\nWHERE salary &gt; (SELECT AVG(salary) FROM employees);<\/code><\/pre>\n<p>No exemplo acima, a subquery calcula o <strong>sal\u00e1rio m\u00e9dio<\/strong> de todos os funcion\u00e1rios, e o resultado \u00e9 usado na cl\u00e1usula WHERE para filtrar funcion\u00e1rios com sal\u00e1rios acima dessa m\u00e9dia.<\/p>\n<h3>Introdu\u00e7\u00e3o \u00e0s Common Table Expressions (CTEs)<\/h3>\n<p>Uma <strong>Common Table Expression (CTE)<\/strong> \u00e9 uma consulta tempor\u00e1ria que voc\u00ea pode definir dentro uma instru\u00e7\u00e3o SELECT. Elas oferecem uma maneira mais leg\u00edvel e organizada para criar consultas complexas, especialmente quando voc\u00ea precisa referenciar a mesma subquery v\u00e1rias vezes.<\/p>\n<h3>Usando a Cl\u00e1usula WITH para Criar CTEs<\/h3>\n<p>A <strong>cl\u00e1usula WITH<\/strong> \u00e9 usada para definir uma CTE. Vamos criar uma CTE que calcula o sal\u00e1rio m\u00e9dio dos departamentos e utiliza esta CTE em uma consulta principal.<\/p>\n<pre><code>WITH AvgDeptSal AS (\n  SELECT department_id, AVG(salary) AS avg_salary\n  FROM employees\n  GROUP BY department_id\n)\nSELECT e.employee_id, e.first_name, e.salary\nFROM employees e\nJOIN AvgDeptSal a ON e.department_id = a.department_id\nWHERE e.salary &gt; a.avg_salary;<\/code><\/pre>\n<p>No exemplo acima, <strong>AvgDeptSal<\/strong> \u00e9 a CTE que calcula o sal\u00e1rio m\u00e9dio por departamento, e a consulta principal utiliza esta informa\u00e7\u00e3o para filtrar os funcion\u00e1rios.<\/p>\n<h3>Verificando a Instala\u00e7\u00e3o \/ Testando a Configura\u00e7\u00e3o<\/h3>\n<p>Ap\u00f3s configurar o ambiente e executar os exemplos, vamos verificar se tudo est\u00e1 correto.<\/p>\n<pre><code>SELECT COUNT(*) FROM employees;<\/code><\/pre>\n<pre><code class=\"output\">105<\/code><\/pre>\n<p>Se o comando acima retornar um n\u00famero, significa que a configura\u00e7\u00e3o est\u00e1 correta e a conex\u00e3o com o banco de dados foi bem-sucedida.<\/p>\n<h3>Erros Comuns e Como Resolver<\/h3>\n<ul>\n<li><strong>ORA-00942:<\/strong> A tabela ou view n\u00e3o existe &#8211; Verifique se todos os nomes de tabelas est\u00e3o corretos.<\/li>\n<li><strong>ORA-00904:<\/strong> Identificador inv\u00e1lido &#8211; Cheque os nomes das colunas utilizados em consultas e subqueries.<\/li>\n<li><strong>ORA-01427:<\/strong> Linha \u00fanica esperada, mas s\u00e3o retornadas m\u00faltiplas &#8211; Isso ocorre quando a subquery n\u00e3o retorna exatamente uma linha para opera\u00e7\u00f5es que esperam um \u00fanico valor.<\/li>\n<li><strong>ORA-06553:<\/strong> PL\/SQL: subprograma retornou erros non\u00e9xistentes &#8211; Assegure-se de que n\u00e3o haja erros de sintaxe nas subqueries e CTEs.<\/li>\n<\/ul>\n<h3>Boas Pr\u00e1ticas e Dicas Avan\u00e7adas<\/h3>\n<p>Durante o desenvolvimento de consultas complexas, sempre prefira o uso de <strong>CTEs<\/strong> quando lidar com subqueries repetidas, pois isso melhora a legibilidade e facilita a manuten\u00e7\u00e3o do c\u00f3digo. Outra dica importante \u00e9 sempre verificar os custos estimados das consultas para otimizar a performance.<\/p>\n<h3>Resumo da Aula 13<\/h3>\n<p>\nNesta aula, exploramos o uso de <strong>Subqueries e CTEs<\/strong> no Oracle SQL, aprendendo a diferenciar suas aplica\u00e7\u00f5es e otimizar consultas para obter resultados interessantes e eficientes. Em nossos projetos na JRT Technology Solutions, aplicamos essas t\u00e9cnicas para refor\u00e7ar a performance e clareza no desenvolvimento de relat\u00f3rios complexos. Na pr\u00f3xima aula, vamos aprofundar em <em>Joins Avan\u00e7ados e Performance Tuning<\/em>, complementando o conhecimento que iniciamos hoje.\n<\/p>\n<div style=\"margin:52px 0 40px;padding:36px 28px;background:linear-gradient(135deg,#0f172a 0%,#1a2744 100%);border:2px solid #25D366;border-radius:18px;text-align:center;box-shadow:0 4px 28px rgba(37,211,102,0.18)\">\n<p style=\"margin:0 0 10px;font-size:18px;color:#ffffff;font-weight:700;line-height:1.4\">Quer aprender na pr\u00e1tica com especialistas?<\/p>\n<p style=\"margin:0 0 28px;font-size:15px;color:#94a3b8;font-weight:400;line-height:1.6\">A JRT Technology Solutions oferece treinamentos e implementa\u00e7\u00e3o de Oracle SQL para equipes corporativas.<\/p>\n<p>  <a href=\"https:\/\/api.whatsapp.com\/send\/?phone=5521980606699&#038;text=Ol%C3%A1!%20Tenho%20interesse%20no%20treinamento%20de%20Oracle%20SQL.&#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:700;padding:15px 32px;border-radius:100px;text-decoration:none;box-shadow:0 4px 16px rgba(37,211,102,0.45);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\"><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\"\/><\/svg><br \/>\n    Falar no WhatsApp<br \/>\n  <\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!<\/p>\n","protected":false},"author":1,"featured_media":1102,"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":[1478,1939,1938,1744,1740],"class_list":["post-1103","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops","tag-common-table-expressions","tag-consultas-aninhadas-sql","tag-cte-with-clause","tag-otimizacao-de-queries","tag-subqueries-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!\" \/>\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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/\" \/>\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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta property=\"og:description\" content=\"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/\" \/>\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-16T21:01:42+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-06-16T21:01:42+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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!\" \/>\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\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#blogposting\",\"name\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions\",\"headline\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions)\",\"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-1781643701493.jpg\",\"width\":1536,\"height\":1024,\"caption\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions)\"},\"datePublished\":\"2026-06-16T18:01:42-03:00\",\"dateModified\":\"2026-06-16T18:01:42-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#webpage\"},\"articleSection\":\"DevOps, Common Table Expressions, consultas aninhadas SQL, CTE WITH clause, otimiza\\u00e7\\u00e3o de queries, subqueries SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#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\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#listItem\",\"name\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#listItem\",\"position\":3,\"name\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions)\",\"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\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#organizationLogo\",\"width\":100,\"height\":75},\"image\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#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\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#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\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#webpage\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/\",\"name\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions\",\"description\":\"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\\u00e1tica!\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#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-1781643701493.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#mainImage\",\"width\":1536,\"height\":1024,\"caption\":\"Aula 13: Subqueries e CTEs \\u2014 WITH clause (Common Table Expressions)\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/06\\\/16\\\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\\\/#mainImage\"},\"datePublished\":\"2026-06-16T18:01:42-03:00\",\"dateModified\":\"2026-06-16T18:01:42-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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions","description":"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!","canonical_url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/","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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#blogposting","name":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions","headline":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)","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-1781643701493.jpg","width":1536,"height":1024,"caption":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)"},"datePublished":"2026-06-16T18:01:42-03:00","dateModified":"2026-06-16T18:01:42-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#webpage"},"isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#webpage"},"articleSection":"DevOps, Common Table Expressions, consultas aninhadas SQL, CTE WITH clause, otimiza\u00e7\u00e3o de queries, subqueries SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#listItem","name":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#listItem","position":3,"name":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)","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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#organizationLogo","width":100,"height":75},"image":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#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\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#webpage","url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/","name":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions","description":"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#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-1781643701493.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#mainImage","width":1536,"height":1024,"caption":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)"},"primaryImageOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/#mainImage"},"datePublished":"2026-06-16T18:01:42-03:00","dateModified":"2026-06-16T18:01:42-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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions","og:description":"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!","og:url":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/","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-16T21:01:42+00:00","article:modified_time":"2026-06-16T21:01:42+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=61590814880509","twitter:card":"summary_large_image","twitter:title":"Aula 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions) - BLOG - JRT Technology Solutions","twitter:description":"Domine Subqueries e CTEs com WITH clause: aprenda a organizar consultas SQL complexas e turbinar suas queries. Aula pr\u00e1tica!","twitter:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg"},"aioseo_meta_data":{"post_id":"1103","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:28:54","updated":"2026-06-22 19:28:54"},"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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)\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 13: Subqueries e CTEs \u2014 WITH clause (Common Table Expressions)","link":"https:\/\/jrtx.com.br\/blog\/2026\/06\/16\/aula-13-subqueries-e-ctes-with-clause-common-table-expressio\/"}],"_links":{"self":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/1103","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=1103"}],"version-history":[{"count":0,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/1103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media\/1102"}],"wp:attachment":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}