{"id":5327,"date":"2026-01-19T16:57:52","date_gmt":"2026-01-19T15:57:52","guid":{"rendered":"https:\/\/sutilweb.eu\/?page_id=5327"},"modified":"2026-01-19T16:57:53","modified_gmt":"2026-01-19T15:57:53","slug":"43-order-by-y-group-by-en-mysql","status":"publish","type":"page","link":"https:\/\/sutilweb.eu\/index.php\/lenguajes\/php\/php-practico\/43-order-by-y-group-by-en-mysql\/","title":{"rendered":"43. Order By y Group By en MySQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">En este cap\u00edtulo hablaremos sobre las sentencias <strong><em>ORDER BY<\/em><\/strong> y <strong><em>GROUP BY<\/em><\/strong>.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><em>ORDER BY<\/em><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Imaginemos que queremos que nos traigan los registros ordenados seg\u00fan un campo, para ello sirve la sentencia <strong><em>ORDER BY<\/em><\/strong>, cuya sintaxis es la siguiente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM ejemplo.contactos ORDER BY nombre;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">En este caso ordenamos los registros ordenados alfab\u00e9ticamente seg\u00fan el campo <strong><em>nombre<\/em><\/strong>. Por defecto, cuando utilizamos esta sentencia, los registros se ordenan de manera ascendente (de la A a la Z), si quisi\u00e9ramos ordenarlos de manera descendente tendr\u00edamos que usar la siguiente sintaxis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM ejemplo.contactos ORDER BY nombre DESC;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">ambi\u00e9n podr\u00edamos utilizar la sentencia <strong><em>ASC<\/em><\/strong> si quisi\u00e9ramos ordenarlo de manera ascendente (la que se ordena por defecto).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><em>GROUP BY<\/em><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Si tenemos varias direcciones repetidas y queremos saber cuantas personas viven en la misma direcci\u00f3n, la sentencia <strong><em>GROUP BY<\/em><\/strong> nos puede ayudar, de la siguiente manera.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT direccion FROM ejemplo.contactos GROUP BY direccion;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esto lo que har\u00e1 es que traer\u00e1 las direcciones \u00fanicas, que no se repiten, pero lo que quiero saber es cuantas personas viven una misma direcci\u00f3n, para ello vamos a hacer uso de la sentencia <strong><em>COUNT(*)<\/em><\/strong> de la siguiente manera.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT direccion, COUNG(*) FROM ejemplo.contactos GROUP BY direccion;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Sentencia <em>HAVING<\/em><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ahora vamos a hacer una consulta en la que nos muestre las direcciones en las que viva m\u00e1s de una persona, para ello hacemos uso al final de nuestra consulta de la sentencia <strong><em>HAVING<\/em><\/strong>, de la siguiente manera.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT direccion, COUNG(*) FROM ejemplo.contactos GROUP BY direccion HAVING COUNT(*) > 1;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Se puede usar para ello los caracteres:<strong><em> &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;, !=<\/em><\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La sentencia <strong><em>HAVING<\/em><\/strong> s\u00f3lo la podemos utilizar en el caso que estemos utilizando la sentencia <strong><em>GROUP BY<\/em><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este cap\u00edtulo hablaremos sobre las sentencias ORDER BY y GROUP BY.&nbsp; ORDER BY Imaginemos que queremos que nos traigan los registros ordenados seg\u00fan un campo, para ello sirve la sentencia ORDER BY, cuya sintaxis es la siguiente. Ejm En este caso ordenamos los registros ordenados alfab\u00e9ticamente seg\u00fan el campo nombre. Por defecto, cuando utilizamos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4518,"menu_order":42,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-5327","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":"En este cap\u00edtulo hablaremos sobre las sentencias ORDER BY y GROUP BY.&nbsp; ORDER BY Imaginemos que queremos que nos traigan los registros ordenados seg\u00fan un campo, para ello sirve la sentencia ORDER BY, cuya sintaxis es la siguiente. Ejm En este caso ordenamos los registros ordenados alfab\u00e9ticamente seg\u00fan el campo nombre. Por defecto, cuando utilizamos&hellip;","_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=5327"}],"version-history":[{"count":3,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5327\/revisions"}],"predecessor-version":[{"id":5330,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5327\/revisions\/5330"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/4518"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=5327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}