{"id":198442,"date":"2023-08-02T07:30:00","date_gmt":"2023-08-02T07:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=198442"},"modified":"2023-11-09T13:44:04","modified_gmt":"2023-11-09T13:44:04","slug":"case-sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/case-sql-tout-savoir","title":{"rendered":"Case SQL : Quelle est cette requ\u00eate et comment l&rsquo;utiliser ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"198442\" class=\"elementor elementor-198442\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5fbb52c e-flex e-con-boxed e-con\" data-id=\"5fbb52c\" 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-00a73a2 elementor-widget elementor-widget-heading\" data-id=\"00a73a2\" 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\">Le langage de programmation SQL est un outil pr\u00e9cieux pour les d\u00e9veloppeurs et les experts. En effet, gr\u00e2ce \u00e0 une multitude de requ\u00eates, il est possible de manipuler les donn\u00e9es et les syst\u00e8mes de <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">bases de donn\u00e9es relationnelles<\/a>. Parmi les commandes incontournables, il y a CASE SQL. \u00c0 quoi sert cette requ\u00eate ? Et comment l\u2019utiliser ? D\u00e9couvrez les r\u00e9ponses dans cet article.<\/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-c3bb4b1 e-flex e-con-boxed e-con\" data-id=\"c3bb4b1\" 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-8327a6b elementor-widget elementor-widget-heading\" data-id=\"8327a6b\" 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\">Qu\u2019est-ce que la commande CASE  ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-89596ec elementor-widget elementor-widget-text-editor\" data-id=\"89596ec\" 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;\">En <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">langage informatique<\/a><\/span><span style=\"font-weight: 400;\">, la commande CASE\/WHEN r\u00e9pond aux m\u00eames objectifs que la fonction SI\/SINON (ou IF\/ELSE). \u00c0 savoir <\/span><b>retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Selon la syntaxe utilis\u00e9e, CASE permet de :<\/span><\/p><p><span style=\"font-weight: 400;\">1\u00ba Comparer une donn\u00e9e \u00e0 un set de r\u00e9sultat possible. Dans ce cas, voici la syntaxe de CASE SQL :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">CASE\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">WHEN expression THEN r\u00e9sultat\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">ELSE autre r\u00e9sultat<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">END<\/span><\/p><p><span style=\"font-weight: 400;\">2 \u00ba D\u00e9terminer un r\u00e9sultat en \u00e9laborant plusieurs expressions bool\u00e9ennes (vrai ou faux). La syntaxe est la suivante :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">CASE\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">WHEN expression bool\u00e9enne THEN r\u00e9sultat\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">ELSE autre r\u00e9sultat<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">END<\/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-6835212 elementor-widget elementor-widget-text-editor\" data-id=\"6835212\" 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><strong>Bon \u00e0 savoir <\/strong><span style=\"font-weight: 400;\"><strong>:<\/strong> dans les deux cas, la clause ELSE est facultative. Cela permet de d\u00e9finir une valeur dans l\u2019hypoth\u00e8se o\u00f9 les conditions WHEN ne sont pas respect\u00e9es.\u00a0<\/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-1b9623f elementor-widget elementor-widget-text-editor\" data-id=\"1b9623f\" 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;\">Au-del\u00e0 de ces syntaxes simplifi\u00e9es, la requ\u00eate CASE SQL est tr\u00e8s souvent utilis\u00e9e avec d\u2019autres commandes. <\/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-cb09c0b e-flex e-con-boxed e-con\" data-id=\"cb09c0b\" 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-fc4474c elementor-widget elementor-widget-heading\" data-id=\"fc4474c\" 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\">Quelles sont les autres commandes \u00e0 utiliser avec CASE SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c24830f elementor-widget elementor-widget-text-editor\" data-id=\"c24830f\" 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;\">Afin d\u2019enrichir la base de donn\u00e9es, la requ\u00eate CASE SQL peut \u00eatre utilis\u00e9e avec d\u2019autres commandes. Voici les principales et leurs diff\u00e9rentes fonctionnalit\u00e9s :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>SELECT<\/strong> : c\u2019est l&rsquo;une des requ\u00eates SQL les plus courantes. Elle permet en effet de s\u00e9lectionner des colonnes \u00e0 l\u2019int\u00e9rieur d\u2019une table.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>UPDATE<\/strong> : cette commande permet de mettre \u00e0 jour une colonne.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>DELETE<\/strong> : il s\u2019agit de supprimer une ou plusieurs colonnes.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>ORDER BY<\/strong> : cette requ\u00eate permet de classer les donn\u00e9es de la table (ordre d\u00e9croissant ou croissant).\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>GROUP BY<\/strong> : cela permet de regrouper des donn\u00e9es en fonction d\u2019une condition d\u00e9finie.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>INSERT INTO<\/strong> : si vous souhaitez ajouter d\u2019autres informations dans votre table de donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>SUM<\/strong> : il s\u2019agit de r\u00e9aliser des sommes (d\u2019un produit, d\u2019un prix, \u2026).\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>HAVING<\/strong> : pour retreindre des lignes. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21e8b61 elementor-widget elementor-widget-text-editor\" data-id=\"21e8b61\" 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;\">Ceci \u00e9tant dit, nous allons voir quelques exemples d\u2019utilisation concrets.<\/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-0155395 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0155395\" 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\">Apprendre \u00e0 utiliser CASE SQL<\/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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1749dbb e-flex e-con-boxed e-con\" data-id=\"1749dbb\" 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-8211a67 elementor-widget elementor-widget-heading\" data-id=\"8211a67\" 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\">3 exemples d\u2019utilisation de CASE SQL <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b72c8c elementor-widget elementor-widget-text-editor\" data-id=\"7b72c8c\" 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;\">Afin de vous aider \u00e0 mieux comprendre l\u2019utilisation de CASE SQL, voici plusieurs exemples concrets.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour chacun d\u2019entre eux, nous allons utiliser ce tableau \u00ab\u00a0Achat\u00a0\u00bb. L\u2019objectif de l\u2019entreprise est de d\u00e9finir le bon prix. Pour cela, elle se base sur le taux de marge r\u00e9alis\u00e9. <\/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-2f9ab2c elementor-widget elementor-widget-html\" data-id=\"2f9ab2c\" 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-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 30px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 118.66px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-hav4\">ID<\/th>\r\n    <th class=\"tg-hav4\">Nom du produit<\/th>\r\n    <th class=\"tg-hav4\">Marge<\/th>\r\n    <th class=\"tg-hav4\">Quantit\u00e9<\/th>\r\n    <th class=\"tg-hav4\">Prix unitaire<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-hav4\">1<\/td>\r\n    <td class=\"tg-c3ow\">Produit 1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">50<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">2<\/td>\r\n    <td class=\"tg-c3ow\">Produit 2<\/td>\r\n    <td class=\"tg-c3ow\">1,25<\/td>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">70<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">3<\/td>\r\n    <td class=\"tg-c3ow\">Produit 3<\/td>\r\n    <td class=\"tg-c3ow\">0,75<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">60<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">4<\/td>\r\n    <td class=\"tg-c3ow\">Produit 4<\/td>\r\n    <td class=\"tg-c3ow\">1,5<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">80<\/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-c0c1d7c elementor-widget elementor-widget-heading\" data-id=\"c0c1d7c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Message personnalis\u00e9<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-886a869 elementor-widget elementor-widget-text-editor\" data-id=\"886a869\" 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;\">L\u2019objectif est d\u2019informer les d\u00e9cisionnaires sur le positionnement des prix de chaque produit. Pour cela, il est possible d\u2019utiliser la requ\u00eate CASE SQL.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici la syntaxe :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT id, nom du produit, marge,quantit\u00e9, prix unitaire,\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0CASE\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN marge &gt; 1 THEN &lsquo;Prix \u00e9lev\u00e9&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN marge &lt; 1 THEN &lsquo;Prix bas&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ELSE &lsquo;Prix normal&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0END<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">FROM `Achat`<\/span><\/p><p><span style=\"font-weight: 400;\">Et le 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-a7a0f68 elementor-widget elementor-widget-html\" data-id=\"a7a0f68\" 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-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-i3d5{background-color:#656565;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 600px\">\r\n<colgroup>\r\n<col style=\"width: 30px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 118.66px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-hav4\">ID<\/th>\r\n    <th class=\"tg-hav4\">Nom du produit<\/th>\r\n    <th class=\"tg-hav4\">Marge<\/th>\r\n    <th class=\"tg-hav4\">Quantit\u00e9<\/th>\r\n    <th class=\"tg-hav4\">Prix unitaire<\/th>\r\n    <th class=\"tg-i3d5\">CASE<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-hav4\">1<\/td>\r\n    <td class=\"tg-c3ow\">Produit 1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">50<\/td>\r\n    <td class=\"tg-baqh\">Prix normal<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">2<\/td>\r\n    <td class=\"tg-c3ow\">Produit 2<\/td>\r\n    <td class=\"tg-c3ow\">1,25<\/td>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">70<\/td>\r\n    <td class=\"tg-baqh\">Prix \u00e9lev\u00e9<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">3<\/td>\r\n    <td class=\"tg-c3ow\">Produit 3<\/td>\r\n    <td class=\"tg-c3ow\">0,75<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">60<\/td>\r\n    <td class=\"tg-baqh\">Prix bas<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">4<\/td>\r\n    <td class=\"tg-c3ow\">Produit 4<\/td>\r\n    <td class=\"tg-c3ow\">1,5<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">80<\/td>\r\n    <td class=\"tg-baqh\">Prix \u00e9lev\u00e9<\/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-4d1e54b elementor-widget elementor-widget-heading\" data-id=\"4d1e54b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Modification du prix unitaire<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ec0854 elementor-widget elementor-widget-text-editor\" data-id=\"2ec0854\" 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;\">Afin d\u2019ajuster sa politique tarifaire, l\u2019entreprise souhaite modifier ses prix en fonction de sa marge : r\u00e9duire de 10 % lorsque la marge est positive et augmenter de 10 %, lorsqu\u2019elle est n\u00e9gative.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u00e0 encore, l\u2019utilisation des conditions et de la commande CASE SQL permettent de modifier rapidement la base de donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici la syntaxe :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT id, nom du produit, marge,quantit\u00e9, prix unitaire,\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0CASE\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN marge &gt; 1 THEN &lsquo;Prix unitaire * 0,9&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN marge &lt; 1 THEN &lsquo;Prix unitaire * 1,1&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ELSE &lsquo;Prix unitaire&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0END<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">FROM `Achat`<\/span><\/p><p><span style=\"font-weight: 400;\">Et le 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-14dee33 elementor-widget elementor-widget-html\" data-id=\"14dee33\" 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-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 30px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 118.66px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-hav4\">ID<\/th>\r\n    <th class=\"tg-hav4\">Nom du produit<\/th>\r\n    <th class=\"tg-hav4\">Marge<\/th>\r\n    <th class=\"tg-hav4\">Quantit\u00e9<\/th>\r\n    <th class=\"tg-hav4\">Prix unitaire<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-hav4\">1<\/td>\r\n    <td class=\"tg-c3ow\">Produit 1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">50<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">2<\/td>\r\n    <td class=\"tg-c3ow\">Produit 2<\/td>\r\n    <td class=\"tg-c3ow\">1,25<\/td>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">63<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">3<\/td>\r\n    <td class=\"tg-c3ow\">Produit 3<\/td>\r\n    <td class=\"tg-c3ow\">0,75<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">66<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">4<\/td>\r\n    <td class=\"tg-c3ow\">Produit 4<\/td>\r\n    <td class=\"tg-c3ow\">1,5<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">72<\/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-35534b0 elementor-widget elementor-widget-heading\" data-id=\"35534b0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Actualisation de la quantit\u00e9<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f0be5a elementor-widget elementor-widget-text-editor\" data-id=\"6f0be5a\" 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;\">Au-del\u00e0 de la SELECT, la requ\u00eate CASE SQL peut aussi \u00eatre utilis\u00e9e avec d\u2019autres commandes, comme UPDATE.<\/span><\/p><p><span style=\"font-weight: 400;\">Afin de vous aider \u00e0 visualiser cette requ\u00eate, voici un sc\u00e9nario hypoth\u00e9tique.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour tous les produits pr\u00e9sentant une marge positive, l\u2019entreprise offre un autre produit suppl\u00e9mentaire. Dans ce cadre, il faudra mettre \u00e0 jour le tableau.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici comment faire :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE `achat`<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET `quantit\u00e9` = (<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0CASE\u00a0\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHEN marge &gt; 1 THEN &lsquo;Quantit\u00e9 +\u00a0 1&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ELSE &lsquo;Quantit\u00e9&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0END<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">)<\/span><\/p><p><span style=\"font-weight: 400;\">Et le 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-5e7529b elementor-widget elementor-widget-html\" data-id=\"5e7529b\" 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-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 30px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 100.66px\">\r\n<col style=\"width: 118.66px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-hav4\">ID<\/th>\r\n    <th class=\"tg-hav4\">Nom du produit<\/th>\r\n    <th class=\"tg-hav4\">Marge<\/th>\r\n    <th class=\"tg-hav4\">Quantit\u00e9<\/th>\r\n    <th class=\"tg-hav4\">Prix unitaire<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-hav4\">1<\/td>\r\n    <td class=\"tg-c3ow\">Produit 1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">50<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">2<\/td>\r\n    <td class=\"tg-c3ow\">Produit 2<\/td>\r\n    <td class=\"tg-c3ow\">1,25<\/td>\r\n    <td class=\"tg-c3ow\">4<\/td>\r\n    <td class=\"tg-c3ow\">70<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">3<\/td>\r\n    <td class=\"tg-c3ow\">Produit 3<\/td>\r\n    <td class=\"tg-c3ow\">0,75<\/td>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">60<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-hav4\">4<\/td>\r\n    <td class=\"tg-c3ow\">Produit 4<\/td>\r\n    <td class=\"tg-c3ow\">1,5<\/td>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">80<\/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-6f2404b elementor-widget elementor-widget-text-editor\" data-id=\"6f2404b\" 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;\">Il ne s\u2019agit que de quelques exemples simplifi\u00e9s. Si vous souhaitez en savoir plus sur les diff\u00e9rents cas d\u2019utilisation de la requ\u00eate CASE SQL, <a href=\"https:\/\/datascientest.com\/formation-sql\">suivez notre formation chez DataScientest<\/a>.<\/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-c613a2b e-flex e-con-boxed e-con\" data-id=\"c613a2b\" 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-91bc12f elementor-widget elementor-widget-heading\" data-id=\"91bc12f\" 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\">D\u00e9veloppez vos comp\u00e9tences en langage informatique avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e0e954 elementor-widget elementor-widget-text-editor\" data-id=\"6e0e954\" 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;\">Au-del\u00e0 de la requ\u00eate CASE SQL, le structured query langage regorge d\u2019une multitude de commandes pour manipuler les bases de donn\u00e9es. Pour toutes les appr\u00e9hender, il est indispensable de se former. C\u2019est justement pour cette raison que nous vous proposons diverses <a href=\"https:\/\/datascientest.com\/formations-data\">formations chez Datascientest<\/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-85bbbb2 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"85bbbb2\" 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\">Devenir expert sur SQL avec DataScientest<\/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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8fe097b e-flex e-con-boxed e-con\" data-id=\"8fe097b\" 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-2972ec4 elementor-widget elementor-widget-html\" data-id=\"2972ec4\" 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\": \"Qu\u2019est-ce que la commande CASE  ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"En langage informatique, la commande CASE\/WHEN r\u00e9pond aux m\u00eames objectifs que la fonction SI\/SINON (ou IF\/ELSE). \u00c0 savoir retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"3 exemples d\u2019utilisation de CASE SQL \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Afin de vous aider \u00e0 mieux comprendre l\u2019utilisation de CASE SQL, voici plusieurs exemples concrets. Pour chacun d\u2019entre eux, nous allons utiliser ce tableau \\\"Achat\\\". L\u2019objectif de l\u2019entreprise est de d\u00e9finir le bon prix. Pour cela, elle se base sur le taux de marge r\u00e9alis\u00e9.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Modification du prix unitaire\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Afin d\u2019ajuster sa politique tarifaire, l\u2019entreprise souhaite modifier ses prix en fonction de sa marge : r\u00e9duire de 10 % lorsque la marge est positive et augmenter de 10 %, lorsqu\u2019elle est n\u00e9gative. L\u00e0 encore, l\u2019utilisation des conditions et de la commande CASE SQL permettent de modifier rapidement la base de donn\u00e9es.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\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>Le langage de programmation SQL est un outil pr\u00e9cieux pour les d\u00e9veloppeurs et les experts. En effet, gr\u00e2ce \u00e0 une multitude de requ\u00eates, il est possible de manipuler les donn\u00e9es et les syst\u00e8mes de bases de donn\u00e9es relationnelles. Parmi les commandes incontournables, il y a CASE SQL. \u00c0 quoi sert cette requ\u00eate ? Et comment [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":198444,"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>Case SQL : Quelle est cette requ\u00eate et comment l&#039;utiliser ?<\/title>\n<meta name=\"description\" content=\"\u00c0 l\u2019image de la fonction IF\/ELSE, la requ\u00eate Case SQL permet de retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.\" \/>\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\/case-sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Case SQL : Quelle est cette requ\u00eate et comment l&#039;utiliser ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/case-sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-02T07:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:44:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_case.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=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/case-sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/case-sql-tout-savoir\",\"name\":\"Case SQL : Quelle est cette requ\u00eate et comment l'utiliser ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-08-02T07:30:00+00:00\",\"dateModified\":\"2023-11-09T13:44:04+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"\u00c0 l\u2019image de la fonction IF\/ELSE, la requ\u00eate Case SQL permet de retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/case-sql-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\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Case SQL : Quelle est cette requ\u00eate et comment l'utiliser ?","description":"\u00c0 l\u2019image de la fonction IF\/ELSE, la requ\u00eate Case SQL permet de retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.","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\/case-sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Case SQL : Quelle est cette requ\u00eate et comment l'utiliser ?","og_url":"https:\/\/datascientest.com\/case-sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-08-02T07:30:00+00:00","article_modified_time":"2023-11-09T13:44:04+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_case.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/case-sql-tout-savoir","url":"https:\/\/datascientest.com\/case-sql-tout-savoir","name":"Case SQL : Quelle est cette requ\u00eate et comment l'utiliser ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-08-02T07:30:00+00:00","dateModified":"2023-11-09T13:44:04+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"\u00c0 l\u2019image de la fonction IF\/ELSE, la requ\u00eate Case SQL permet de retourner un r\u00e9sultat parmi plusieurs possibilit\u00e9s.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/case-sql-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\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198442"}],"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\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=198442"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/198444"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=198442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=198442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=198442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}