{"id":200040,"date":"2023-05-29T07:00:00","date_gmt":"2023-05-29T07:00:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=200040"},"modified":"2023-11-09T13:52:23","modified_gmt":"2023-11-09T13:52:23","slug":"sql-group-by-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-group-by-tout-savoir","title":{"rendered":"GROUP BY : Tout savoir de cette requ\u00eate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"200040\" class=\"elementor elementor-200040\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1da78ba e-flex e-con-boxed e-con\" data-id=\"1da78ba\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-25c26c4 elementor-widget elementor-widget-heading\" data-id=\"25c26c4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. Elle autorise, en toute simplicit\u00e9, la g\u00e9n\u00e9ration de statistiques avanc\u00e9es \u00e0 partir de cat\u00e9gories. Autant le dire, c\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s'agit.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8e97316 e-flex e-con-boxed e-con\" data-id=\"8e97316\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3a4f6a6 elementor-widget elementor-widget-text-editor\" data-id=\"3a4f6a6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Les atouts de SQL ne sont plus \u00e0 d\u00e9montrer. Ce langage offre un <strong>niveau d\u2019abstraction hors pair pour analyser de vastes volumes d\u2019information<\/strong>. Quel que soit le logiciel de base de donn\u00e9es utilis\u00e9 (<a href=\"https:\/\/datascientest.com\/mysql-tout-comprendre\">MySQL<\/a><\/span><span style=\"font-weight: 400;\">, Ingres, Oracle Database, Microsoft SQL Server, PostgreSQL, SQLite, Firebird\u2026), le data analyst sait qu\u2019il obtiendra le r\u00e9sultat d\u00e9sir\u00e9 sans avoir \u00e0 en programmer la logique pr\u00e9cise.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f619477 e-flex e-con-boxed e-con\" data-id=\"f619477\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1cea712 elementor-widget elementor-widget-heading\" data-id=\"1cea712\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment regrouper les informations d\u2019une base de donn\u00e9es ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fbaa7df elementor-widget elementor-widget-text-editor\" data-id=\"fbaa7df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">S\u2019il est une commande particuli\u00e8rement importante et fort appr\u00e9ciable, c\u2019est GROUP BY. Elle <\/span><b>regroupe des informations<\/b><span style=\"font-weight: 400;\"> d\u2019une base selon une colonne particuli\u00e8re, \u00e0 partir de laquelle, il sera possible d\u2019obtenir des<\/span><b> informations statistiques<\/b><span style=\"font-weight: 400;\"> : somme, maximum, minimum, moyenne, etc.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour mieux appr\u00e9hender ce concept, le plus simple est de partir d\u2019un exemple. Voici un extrait d\u2019une table appel\u00e9e Personnel.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61bcf65 elementor-widget elementor-widget-html\" data-id=\"61bcf65\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8a1x{background-color:#6665cd;color:#efefef;font-family:Tahoma, Geneva, sans-serif !important;font-size:20px;\r\n  font-weight:bold;text-align:center;vertical-align:top}\r\n.tg .tg-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 300px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8a1x\">Nom<\/th>\r\n    <th class=\"tg-8a1x\">Service<\/th>\r\n    <th class=\"tg-8a1x\">Salaire<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Paul<\/td>\r\n    <td class=\"tg-r3ey\">Finances<\/td>\r\n    <td class=\"tg-r3ey\">3 000<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Ray<\/td>\r\n    <td class=\"tg-r3ey\">Ventes<\/td>\r\n    <td class=\"tg-r3ey\">2 500<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Julia<\/td>\r\n    <td class=\"tg-r3ey\">Finances<\/td>\r\n    <td class=\"tg-r3ey\">3 200<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Dan<\/td>\r\n    <td class=\"tg-r3ey\">Marketing<\/td>\r\n    <td class=\"tg-r3ey\">4 300<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Josie<\/td>\r\n    <td class=\"tg-r3ey\">Ventes<\/td>\r\n    <td class=\"tg-r3ey\">2 200<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Donna<\/td>\r\n    <td class=\"tg-r3ey\">Finances<\/td>\r\n    <td class=\"tg-r3ey\">2 700<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4b223f elementor-widget elementor-widget-text-editor\" data-id=\"d4b223f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si nous voulions obtenir la somme des salaires par service, il suffirait d\u2019utiliser une s\u00e9quence telle que celle-ci :<\/span><\/p><p style=\"padding-left: 40px;\">SELECT Service, SUM(Salaire)<br \/><br \/>FROM Personnel<br \/><br \/>GROUP BY Service<br \/><br \/>ORDER BY Service;<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77c36af elementor-widget elementor-widget-text-editor\" data-id=\"77c36af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Dans cet exemple, nous regroupons la table selon la colonne Service et demandons \u00e0 obtenir la somme des salaires pour chacun d\u2019entre eux.<\/span><\/p><p><span style=\"font-weight: 400;\">Nous obtiendrions en r\u00e9ponse &#8211; sur l\u2019\u00e9chantillon indiqu\u00e9 plus haut :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eda38cb elementor-widget elementor-widget-html\" data-id=\"eda38cb\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 200px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-r3ey\">Finances<\/th>\r\n    <th class=\"tg-r3ey\">8 900<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Marketing<\/td>\r\n    <td class=\"tg-r3ey\">4 300<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Ventes<\/td>\r\n    <td class=\"tg-r3ey\">4 700<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4d5166c e-flex e-con-boxed e-con\" data-id=\"4d5166c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3d0b032 elementor-widget elementor-widget-heading\" data-id=\"3d0b032\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment utiliser la clause HAVING BY ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bf8d4f6 elementor-widget elementor-widget-text-editor\" data-id=\"bf8d4f6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">HAVING BY<\/span><b> compl\u00e8te la commande<\/b><span style=\"font-weight: 400;\"> GROUP BY en ouvrant <\/span><b>la possibilit\u00e9 d\u2019indiquer une condition<\/b><span style=\"font-weight: 400;\">. Ainsi, dans l\u2019exemple ci-dessous, nous souhaitons afficher la moyenne des salaires (la fonction AVG) mais uniquement si cette moyenne est sup\u00e9rieure \u00e0 2500 :<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT Service, AVG(Salaire)<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">FROM Personnel<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">GROUP BY Service<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">HAVING AVG(Salaire) &gt; 2500<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">ORDER BY Service;<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5df7e12 elementor-widget elementor-widget-text-editor\" data-id=\"5df7e12\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Nous obtenons en r\u00e9sultat :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53763e8 elementor-widget elementor-widget-html\" data-id=\"53763e8\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 200px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-r3ey\">Finances<\/th>\r\n    <th class=\"tg-r3ey\">2 967<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Marketing<\/td>\r\n    <td class=\"tg-r3ey\">4 300<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91627de elementor-widget elementor-widget-text-editor\" data-id=\"91627de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Et voil\u00e0 ! C\u2019est aussi simple que cela. La facilit\u00e9 avec laquelle de telles op\u00e9rations sont mises en \u0153uvre t\u00e9moigne des <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">qualit\u00e9s du langage SQL<\/a>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c447ad elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1c447ad\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former au langage SQL pour la data<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bde0b1f elementor-widget elementor-widget-html\" data-id=\"bde0b1f\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser la clause HAVING BY ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"HAVING BY compl\u00e8te la commande GROUP BY en ouvrant la possibilit\u00e9 d\u2019indiquer une condition.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment regrouper les informations d\u2019une base de donn\u00e9es ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"S\u2019il est une commande particuli\u00e8rement importante et fort appr\u00e9ciable, c\u2019est GROUP BY. Elle regroupe des informations d\u2019une base selon une colonne particuli\u00e8re, \u00e0 partir de laquelle, il sera possible d\u2019obtenir des informations statistiques : somme, maximum, minimum, moyenne, etc.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. Elle autorise, en toute simplicit\u00e9, la g\u00e9n\u00e9ration de statistiques avanc\u00e9es \u00e0 partir de cat\u00e9gories. Autant le dire, c\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s&rsquo;agit. Les atouts de SQL ne sont plus [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":200042,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GROUP BY : Tout savoir de cette requ\u00eate<\/title>\n<meta name=\"description\" content=\"L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. C\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s&#039;agit.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/sql-group-by-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GROUP BY : Tout savoir de cette requ\u00eate\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-group-by-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-29T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:52:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/sql-group-by-datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-group-by-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-group-by-tout-savoir\",\"name\":\"GROUP BY : Tout savoir de cette requ\u00eate\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-05-29T07:00:00+00:00\",\"dateModified\":\"2023-11-09T13:52:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. C\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s'agit.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-group-by-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"GROUP BY : Tout savoir de cette requ\u00eate","description":"L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. C\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s'agit.","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:\/\/datascientest.com\/sql-group-by-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"GROUP BY : Tout savoir de cette requ\u00eate","og_url":"https:\/\/datascientest.com\/sql-group-by-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-05-29T07:00:00+00:00","article_modified_time":"2023-11-09T13:52:23+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/sql-group-by-datascientest.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-group-by-tout-savoir","url":"https:\/\/datascientest.com\/sql-group-by-tout-savoir","name":"GROUP BY : Tout savoir de cette requ\u00eate","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-05-29T07:00:00+00:00","dateModified":"2023-11-09T13:52:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"L\u2019une des commandes SQL les plus utiles pour le Data Analyst est GROUP BY. C\u2019est une des 10 commandes que vous utiliserez le plus, donc autant savoir de quoi il s'agit.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-group-by-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/200040"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=200040"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/200040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/200042"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=200040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=200040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=200040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}