{"id":19892,"date":"2023-05-16T06:52:00","date_gmt":"2023-05-16T04:52:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=19892"},"modified":"2023-06-19T20:52:25","modified_gmt":"2023-06-19T18:52:25","slug":"requete-group-by-en-t-sql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/","title":{"rendered":"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Exemples de requ\u00eates GROUP BY en T-SQL pour agr\u00e9ger les donn\u00e9es d&rsquo;une table avec SQL Server.<\/em><\/strong><\/h4>\n\n\n\n<p>La requ\u00eate GROUP BY en T-SQL est une clause utilis\u00e9e dans le code SQL Server ou SQL standard pour regrouper les lignes d&rsquo;un r\u00e9sultat de requ\u00eate selon une ou plusieurs colonnes. La clause GROUP BY est g\u00e9n\u00e9ralement utilis\u00e9e avec les fonctions d&rsquo;agr\u00e9gation telles que SUM, AVG, MAX, MIN, COUNT, etc. pour produire des r\u00e9sultats group\u00e9s. Voici 10 exemples concrets de l&rsquo;utilisation de la clause GROUP BY dans T-SQL.<\/p>\n\n\n\n<p>Dans tous ces exemples, la requ\u00eate GROUP BY en T-SQL regroupe les lignes en fonction de la ou des colonnes sp\u00e9cifi\u00e9es, et les <a href=\"https:\/\/lexique.netmath.ca\/maximum\/\" target=\"_blank\" rel=\"noreferrer noopener\">fonctions d&rsquo;agr\u00e9gation<\/a> sont utilis\u00e9es pour produire des r\u00e9sultats group\u00e9s, c&rsquo;est \u00e0 dire agr\u00e9g\u00e9s.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#1-creer-les-tables-dexemples-pour-les-requetes-group-by\" >1. Cr\u00e9er les tables d&rsquo;exemples pour les requ\u00eates GROUP BY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#2-requete-sql-server-pour-calculer-la-somme-des-ventes-par-annee\" >2. Requ\u00eate SQL Server pour calculer la somme des ventes par ann\u00e9e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#3-nombre-de-commandes-par-client-avec-une-requete-t-sql\" >3. Nombre de commandes par client avec une requ\u00eate T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#4-group-by-avec-le-total-des-ventes-par-annee-et-par-pays\" >4. GROUP BY avec le total des ventes par ann\u00e9e et par pays<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#5-requete-group-by-pour-afficher-les-commandes-par-pays-et-annee\" >5. Requ\u00eate GROUP BY pour afficher les commandes par pays et ann\u00e9e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#6-calculer-le-total-des-commandes-avec-group-by-et-count\" >6. Calculer le total des commandes avec GROUP BY et COUNT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#7-moyenne-par-mois-et-annee-avec-group-by-year-month-et-avg\" >7. Moyenne par mois et ann\u00e9e avec GROUP BY, YEAR, MONTH et AVG<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#8-requete-group-by-avec-les-commandes-par-categorie-et-annee\" >8. Requ\u00eate GROUP BY avec les commandes par cat\u00e9gorie et ann\u00e9e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#9-calculer-le-prix-le-plus-eleve-paye-par-client-en-t-sql\" >9. Calculer le prix le plus \u00e9lev\u00e9 pay\u00e9 par client en T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#10-nombre-de-commandes-pour-chaque-produit-avec-group-by\" >10. Nombre de commandes pour chaque produit avec GROUP BY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#11-somme-des-ventes-par-categorie-et-par-annee-avec-une-requete-t-sql\" >11. Somme des ventes par cat\u00e9gorie et par ann\u00e9e avec une requ\u00eate T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#12-conclusion-sur-le-group-by-avec-sql-server\" >12. Conclusion sur le GROUP BY avec SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-creer-les-tables-dexemples-pour-les-requetes-group-by\"><\/span>1. Cr\u00e9er les tables d&rsquo;exemples pour les requ\u00eates GROUP BY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour simplifier le tutoriel, voici des scripts pr\u00eats et fonctionnels pour cr\u00e9er des tables et ex\u00e9cuter les requ\u00eates. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 Requ\u00eate pour cr\u00e9er la table des produits<\/h3>\n\n\n\n<p>Voici le code de cr\u00e9ation de la table des produits avec 10 lignes de donn\u00e9es.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9ation de la table dbo.Products\nCREATE TABLE products (\n   product_id INT PRIMARY KEY,\n   name VARCHAR(255) NOT NULL,\n   category VARCHAR(255) NOT NULL,\n   quantity INT NOT NULL,\n   price DECIMAL(10,2) NOT NULL,\n   purchase_price DECIMAL(10,2) NOT NULL\n);\n\n-- Insertion de quelques lignes dans la table dbo.Products\nINSERT INTO products \n   (product_id, name, category, quantity, price, purchase_price)\nVALUES (1, 'Ordinateur portable', 'Informatique', 10, 1000, 500),\n       (2, 'Tablette tactile', 'Informatique', 5, 500, 250),\n       (3, 'T\u00e9l\u00e9viseur LED', 'Electronique', 20, 2000, 1000),\n       (4, 'Smartphone', 'Electronique', 15, 300, 150),\n       (5, 'Aspirateur', 'Electrom\u00e9nager', 30, 100, 50),\n       (6, 'Lave-linge', 'Electrom\u00e9nager', 25, 500, 250),\n       (7, 'R\u00e9frig\u00e9rateur', 'Electrom\u00e9nager', 35, 700, 350),\n       (8, 'Four micro-ondes', 'Electrom\u00e9nager', 40, 100, 50),\n       (9, 'Machine \u00e0 laver', 'Electrom\u00e9nager', 45, 800, 400),\n       (10, 'Hotte aspirante', 'Electrom\u00e9nager', 50, 150, 75);\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.2 Requ\u00eate pour cr\u00e9er la table des commandes<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9er la table des commandes : dbo.Orders\nCREATE TABLE dbo.Orders(\n   order_id INT PRIMARY KEY,\n   customer_id INT NOT NULL,\n   order_date DATE NOT NULL,\n   product_id INT NOT NULL,\n   quantity INT NOT NULL,\n   price DECIMAL(10,2) NOT NULL,\n   sales DECIMAL(10,2) NOT NULL\n);\n\n-- Insertion de quelques lignes dans la table dbo.Orders\nINSERT INTO dbo.Orders \n   (order_id, customer_id, order_date, product_id, quantity, price, sales)\nVALUES (1, 1, '2022-01-01', 1, 2, 1000, 2000),\n       (2, 2, '2022-01-02', 2, 3, 500, 1500),\n       (3, 3, '2022-01-03', 3, 1, 2000, 2000),\n       (4, 4, '2022-01-04', 4, 5, 300, 1500),\n       (5, 5, '2022-01-05', 5, 1, 100, 100),\n       (6, 6, '2022-01-06', 6, 2, 500, 1000),\n       (7, 7, '2022-01-07', 7, 1, 700, 700),\n       (8, 8, '2022-01-08', 8, 4, 100, 400),\n       (9, 9, '2022-01-09', 9, 1, 800, 800),\n       (10, 10, '2022-01-10', 10, 2, 150, 300);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-requete-sql-server-pour-calculer-la-somme-des-ventes-par-annee\"><span class=\"ez-toc-section\" id=\"2-requete-sql-server-pour-calculer-la-somme-des-ventes-par-annee\"><\/span>2. Requ\u00eate SQL Server pour calculer la somme des ventes par ann\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir la somme des ventes par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   year,\n   SUM(sales)\nFROM dbo.Orders\nGROUP BY\n   year;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-nombre-de-commandes-par-client-avec-une-requete-t-sql\"><\/span>3. Nombre de commandes par client avec une requ\u00eate T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le nombre de commandes pour chaque client, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   customer_id,\n   COUNT(*)\nFROM dbo.Orders\nGROUP BY\n   customer_id;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-group-by-avec-le-total-des-ventes-par-annee-et-par-pays\"><\/span>4. GROUP BY avec le total des ventes par ann\u00e9e et par pays<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le total des ventes par ann\u00e9e et par pays, vous pouvez utiliser la requ\u00eate suivante :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   year,\n   country,\n   SUM(sales)\nFROM dbo.Orders\nGROUP BY\n   year,\n   country;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-requete-group-by-pour-afficher-les-commandes-par-pays-et-annee\"><\/span>5. Requ\u00eate GROUP BY pour afficher les commandes par pays et ann\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le nombre de commandes par pays et par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   year,\n   country,\n   COUNT(*)\nFROM dbo.Orders\nGROUP BY\n   year,\n   country;\n<\/pre>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"8NR7jJtbR0\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\">Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/embed\/#?secret=asGKiaEnsr#?secret=8NR7jJtbR0\" data-secret=\"8NR7jJtbR0\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-calculer-le-total-des-commandes-avec-group-by-et-count\"><\/span>6. Calculer le total des commandes avec GROUP BY et COUNT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le nombre de commandes par produit et par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   year,\n   product_id,\n   COUNT(*)\nFROM dbo.Orders\nGROUP BY\n   year,\n   product_id;\n<\/pre>\n\n\n\n<p>Voici maintenant cinq exemples de code plus complexes utilisant la clause GROUP BY avec les diff\u00e9rentes fonctions d&rsquo;agr\u00e9gation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-moyenne-par-mois-et-annee-avec-group-by-year-month-et-avg\"><\/span>7. Moyenne par mois et ann\u00e9e avec GROUP BY, YEAR, MONTH et AVG<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir la moyenne des quantit\u00e9s command\u00e9es par mois et par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   YEAR(order_date) AS year,\n   MONTH(order_date) AS month,\n   AVG(quantity)\nFROM orders\nGROUP BY\n   YEAR(order_date),\n   MONTH(order_date);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-requete-group-by-avec-les-commandes-par-categorie-et-annee\"><\/span>8. Requ\u00eate GROUP BY avec les commandes par cat\u00e9gorie et ann\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le nombre de commandes par cat\u00e9gorie de produit et par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   YEAR(order_date) AS year,\n   p.category, COUNT(*)\nFROM dbo.Orders o\nINNER JOIN dbo.Products p\n   ON o.product_id = p.product_id\nGROUP BY\n   YEAR(order_date),\n   p.category;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9-calculer-le-prix-le-plus-eleve-paye-par-client-en-t-sql\"><\/span>9. Calculer le prix le plus \u00e9lev\u00e9 pay\u00e9 par client en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le prix le plus \u00e9lev\u00e9 pay\u00e9 par chaque client, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   customer_id,\n   MAX(price)\nFROM dbo.Orders\nGROUP BY\n   customer_id;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10-nombre-de-commandes-pour-chaque-produit-avec-group-by\"><\/span>10. Nombre de commandes pour chaque produit avec GROUP BY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir le nombre de commandes contenant chaque produit, vous pouvez utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   product_id,\n   COUNT(*)\nFROM dbo.Orders\nGROUP BY\n   product_id;\n<\/pre>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"lQftqRnZ1p\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/les-operateurs-de-comparaison-t-sql\/\">Comparer des valeurs avec les op\u00e9rateurs de comparaison logiques T-SQL<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Comparer des valeurs avec les op\u00e9rateurs de comparaison logiques T-SQL\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/les-operateurs-de-comparaison-t-sql\/embed\/#?secret=fyshSVJtPR#?secret=lQftqRnZ1p\" data-secret=\"lQftqRnZ1p\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-somme-des-ventes-par-categorie-et-par-annee-avec-une-requete-t-sql\"><\/span>11. Somme des ventes par cat\u00e9gorie et par ann\u00e9e avec une requ\u00eate T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour obtenir la somme des ventes par cat\u00e9gorie de produit et par ann\u00e9e, vous pouvez utiliser la requ\u00eate suivante :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   YEAR(order_date) AS year,\n   p.category,\n   SUM(o.sales)\nFROM orders o\nINNER JOIN products p\n   ON o.product_id = p.product_id\nGROUP BY\n   YEAR(order_date),\n   p.category;\n<\/pre>\n\n\n\n<p>L&rsquo;utilit\u00e9 de la clause GROUP BY r\u00e9side dans sa capacit\u00e9 \u00e0 r\u00e9sumer et \u00e0 agr\u00e9ger les donn\u00e9es d&rsquo;une table ou d&rsquo;une vue, ce qui peut \u00eatre tr\u00e8s utile dans de nombreux cas. Par exemple, vous pouvez utiliser GROUP BY pour obtenir la somme des ventes par ann\u00e9e, le nombre de commandes par client, le total des ventes par pays et par ann\u00e9e, ou encore le nombre de commandes par produit et par ann\u00e9e.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12-conclusion-sur-le-group-by-avec-sql-server\"><\/span>12. Conclusion sur le GROUP BY avec SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Il est important de noter que la clause GROUP BY doit \u00eatre utilis\u00e9e avec prudence, car elle peut avoir un impact sur les performances de la requ\u00eate si elle est utilis\u00e9e de mani\u00e8re inappropri\u00e9e. En effet, la clause GROUP BY peut \u00eatre co\u00fbteuse en termes de ressources si elle est utilis\u00e9e sur une grande table ou si elle est combin\u00e9e avec d&rsquo;autres clauses co\u00fbteuses telles que DISTINCT ou ORDER BY. Il est donc recommand\u00e9 de bien comprendre comment fonctionne GROUP BY et de l&rsquo;utiliser de mani\u00e8re appropri\u00e9e dans vos requ\u00eates SQL.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Agr\u00e9gation de donn\u00e9es avec SSIS<\/h4>\n\n\n\n<p>Pour aller plus loin, voici d&rsquo;autres fa\u00e7ons d&rsquo;aggr\u00e9ger des donn\u00e9es avec SQL Server , cette fois avec SSIS. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\">Agr\u00e9ger des donn\u00e9es avec SSIS et Aggregate<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/fr\/ssis\/grouper-plusieurs-tables-avec-ssis-union-all\/\">Grouper les donn\u00e9es de plusieurs tables avec SSIS<\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"tpzqf6Mhvm\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/grouper-plusieurs-tables-avec-ssis-union-all\/\">Grouper plusieurs tables avec SSIS Union All<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Grouper plusieurs tables avec SSIS Union All\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/grouper-plusieurs-tables-avec-ssis-union-all\/embed\/#?secret=ver165Q0Jj#?secret=tpzqf6Mhvm\" data-secret=\"tpzqf6Mhvm\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Exemples de requ\u00eates GROUP BY en T-SQL pour agr\u00e9ger les donn\u00e9es d&rsquo;une table avec SQL Server. La requ\u00eate GROUP BY en T-SQL est une clause utilis\u00e9e dans le code SQL Server ou SQL standard pour regrouper les lignes d&rsquo;un <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\" title=\"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-19892","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Requ\u00eate GROUP BY en T-SQL - Agr\u00e9gation - SQL Server<\/title>\n<meta name=\"description\" content=\"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d&#039;un r\u00e9sultat d&#039;une requ\u00eate selon une ou plusieurs colonnes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es\" \/>\n<meta property=\"og:description\" content=\"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d&#039;un r\u00e9sultat d&#039;une requ\u00eate selon une ou plusieurs colonnes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-16T04:52:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-19T18:52:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es\",\"datePublished\":\"2023-05-16T04:52:00+00:00\",\"dateModified\":\"2023-06-19T18:52:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\"},\"wordCount\":814,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\",\"name\":\"Requ\u00eate GROUP BY en T-SQL - Agr\u00e9gation - SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg\",\"datePublished\":\"2023-05-16T04:52:00+00:00\",\"dateModified\":\"2023-06-19T18:52:25+00:00\",\"description\":\"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d'un r\u00e9sultat d'une requ\u00eate selon une ou plusieurs colonnes.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Requ\u00eate GROUP BY en T-SQL - Agr\u00e9gation - SQL Server","description":"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d'un r\u00e9sultat d'une requ\u00eate selon une ou plusieurs colonnes.","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:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es","og_description":"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d'un r\u00e9sultat d'une requ\u00eate selon une ou plusieurs colonnes.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-16T04:52:00+00:00","article_modified_time":"2023-06-19T18:52:25+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es","datePublished":"2023-05-16T04:52:00+00:00","dateModified":"2023-06-19T18:52:25+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/"},"wordCount":814,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/","name":"Requ\u00eate GROUP BY en T-SQL - Agr\u00e9gation - SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg","datePublished":"2023-05-16T04:52:00+00:00","dateModified":"2023-06-19T18:52:25+00:00","description":"La requ\u00eate GROUP BY en T-SQL permet de regrouper les lignes d'un r\u00e9sultat d'une requ\u00eate selon une ou plusieurs colonnes.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-BB67D4004E4_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-group-by-en-t-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Requ\u00eate GROUP BY en T-SQL pour agr\u00e9ger des donn\u00e9es"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=19892"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19892\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10532"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=19892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=19892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=19892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}