{"id":15260,"date":"2025-09-25T21:27:34","date_gmt":"2025-09-25T19:27:34","guid":{"rendered":"https:\/\/www.palentino.es\/blog\/?p=15260"},"modified":"2025-09-25T21:28:50","modified_gmt":"2025-09-25T19:28:50","slug":"orden-logico-de-una-consulta-sql","status":"publish","type":"post","link":"https:\/\/www.palentino.es\/blog\/orden-logico-de-una-consulta-sql\/","title":{"rendered":"Orden l\u00f3gico de una consulta SQL"},"content":{"rendered":"<div id=\"palen-284275963\" class=\"palen-antes-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"4593837716\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p data-start=\"88\" data-end=\"346\">Ojal\u00e1 cuando estudiaba bases de datos y las consultas <strong data-start=\"142\" data-end=\"156\">SQL SELECT<\/strong> hubiera tenido una herramienta as\u00ed. Siempre me costaba visualizar el orden l\u00f3gico de una consulta: primero el <strong data-start=\"267\" data-end=\"275\">FROM<\/strong>, luego el <strong data-start=\"286\" data-end=\"294\">JOIN<\/strong>, despu\u00e9s el <strong data-start=\"307\" data-end=\"316\">WHERE<\/strong>\u2026 hasta llegar al <strong data-start=\"334\" data-end=\"343\">LIMIT<\/strong>.<\/p>\n<p data-start=\"348\" data-end=\"675\">Por eso he creado esta web interactiva, pensada para estudiantes, profesionales o curiosos que quieran <strong data-start=\"451\" data-end=\"520\">entender paso a paso c\u00f3mo se construye y ejecuta una consulta SQL<\/strong>. Con ejemplos claros, datos editables y un recorrido visual, puedes ver qu\u00e9 filas entran, cu\u00e1les se filtran y c\u00f3mo cambian los resultados en cada etapa.<\/p>\n<p data-start=\"677\" data-end=\"825\">Lo he hecho porque creo que <strong data-start=\"705\" data-end=\"756\">aprender SQL deber\u00eda ser m\u00e1s intuitivo y visual<\/strong>, y porque me hubiera encantado contar con algo as\u00ed en mis inicios.<\/p>\n<p data-start=\"677\" data-end=\"825\">Juega con tus datos y observa c\u00f3mo act\u00faan\u00a0<strong>WHERE<\/strong>,\u00a0<strong>GROUP BY<\/strong>\u00a0y\u00a0<strong>HAVING<\/strong>\u00a0(COUNT\/SUM\/AVG\/MIN\/MAX).<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/palentino.es\/webs\/Consulta-orden-logico-SQL-palentino.html\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/palentino.es\/web\/Orden-logico-sql.gif\" alt=\"\" width=\"1343\" height=\"916\" \/><\/a><\/p>\n<div id=\"palen-2296235045\" class=\"palen-despues-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"\" \ndata-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Ojal\u00e1 cuando estudiaba bases de datos y las consultas SQL SELECT hubiera tenido una herramienta as\u00ed. Siempre me costaba visualizar el orden l\u00f3gico de una consulta: primero el FROM, luego el JOIN, despu\u00e9s el WHERE\u2026 hasta llegar al LIMIT. Por eso he creado esta web interactiva, pensada para estudiantes, profesionales o curiosos que quieran entender paso a paso c\u00f3mo se construye y ejecuta una consulta SQL. Con ejemplos claros, datos editables y un recorrido visual, puedes ver qu\u00e9 filas entran, cu\u00e1les se filtran y c\u00f3mo cambian los resultados en cada etapa. Lo he hecho porque creo que aprender SQL deber\u00eda ser m\u00e1s intuitivo y visual, y porque me hubiera encantado contar con algo as\u00ed en mis inicios. Juega con tus datos y observa c\u00f3mo act\u00faan\u00a0WHERE,\u00a0GROUP BY\u00a0y\u00a0HAVING\u00a0(COUNT\/SUM\/AVG\/MIN\/MAX). &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":11239,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[2328],"tags":[39],"class_list":["post-15260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql"],"views":533,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2024\/02\/Sql-PAlentino.gif","jetpack_shortlink":"https:\/\/wp.me\/p2ECph-3Y8","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/15260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/comments?post=15260"}],"version-history":[{"count":3,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/15260\/revisions"}],"predecessor-version":[{"id":15263,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/15260\/revisions\/15263"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media\/11239"}],"wp:attachment":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media?parent=15260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/categories?post=15260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/tags?post=15260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}