{"id":12703,"date":"2024-03-14T16:26:23","date_gmt":"2024-03-14T16:26:23","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/"},"modified":"2025-08-05T05:37:38","modified_gmt":"2025-08-05T05:37:38","slug":"how-to-use-sql-case-when-statements","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/","title":{"rendered":"SQL CASE WHEN: How to Use"},"content":{"rendered":"<p>The CASE WHEN statement is a type of conditional statement in SQL that is used to return different values based on different conditions.<\/p>\n<p>The basic syntax is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CASE<\/span>\r\n    <span class=\"hljs-keyword\">WHEN<\/span> condition1 <span class=\"hljs-keyword\">THEN<\/span> result1\r\n    <span class=\"hljs-keyword\">WHEN<\/span> condition2 <span class=\"hljs-keyword\">THEN<\/span> result2\r\n    ...\r\n    <span class=\"hljs-keyword\">ELSE<\/span> <span class=\"hljs-keyword\">result<\/span>\r\n<span class=\"hljs-keyword\">END<\/span>\r\n<\/code><\/pre>\n<p>condition1, condition2, and so on are conditional expressions that can be any boolean expression. result1, result2, and so on are the results obtained based on the conditions calculated.<\/p>\n<p>Here is an example, providing corresponding comments based on different grade levels.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> grade,\r\n       <span class=\"hljs-keyword\">CASE<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> grade <span class=\"hljs-operator\">&gt;=<\/span> <span class=\"hljs-number\">90<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'\u4f18\u79c0'<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> grade <span class=\"hljs-operator\">&gt;=<\/span> <span class=\"hljs-number\">80<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'\u826f\u597d'<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> grade <span class=\"hljs-operator\">&gt;=<\/span> <span class=\"hljs-number\">70<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'\u4e2d\u7b49'<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> grade <span class=\"hljs-operator\">&gt;=<\/span> <span class=\"hljs-number\">60<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'\u53ca\u683c'<\/span>\r\n           <span class=\"hljs-keyword\">ELSE<\/span> <span class=\"hljs-string\">'\u4e0d\u53ca\u683c'<\/span>\r\n       <span class=\"hljs-keyword\">END<\/span> <span class=\"hljs-keyword\">AS<\/span> comment\r\n<span class=\"hljs-keyword\">FROM<\/span> scores;\r\n<\/code><\/pre>\n<p>In this example, based on the different ranges of grades, the corresponding comments are returned. If the grade is greater than or equal to 90, the comment is &#8216;excellent&#8217;, if the grade is between 80 and 89, the comment is &#8216;good&#8217;, and so on.<\/p>\n<p>It&#8217;s important to note that the CASE WHEN statement is evaluated in order, and only the result of the first condition that is met will be returned. If no conditions are met, the result after ELSE will be returned.<\/p>\n<p>The CASE WHEN statement can also be nested to achieve more complex condition evaluation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The CASE WHEN statement is a type of conditional statement in SQL that is used to return different values based on different conditions. The basic syntax is as follows: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 &#8230; ELSE result END condition1, condition2, and so on are conditional expressions that can be any boolean [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[16701,16702,16703,16700,569],"class_list":["post-12703","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-case-statement-sql","tag-conditional-sql","tag-database-querying","tag-sql-case-when","tag-sql-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL CASE WHEN: How to Use - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master SQL CASE WHEN syntax &amp; usage with examples. Learn conditional logic for smarter database queries.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL CASE WHEN: How to Use\" \/>\n<meta property=\"og:description\" content=\"Master SQL CASE WHEN syntax &amp; usage with examples. Learn conditional logic for smarter database queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T16:26:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T05:37:38+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"SQL CASE WHEN: How to Use\",\"datePublished\":\"2024-03-14T16:26:23+00:00\",\"dateModified\":\"2025-08-05T05:37:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\"},\"wordCount\":170,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"CASE Statement SQL\",\"Conditional SQL\",\"Database Querying\",\"SQL CASE WHEN\",\"sql tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\",\"name\":\"SQL CASE WHEN: How to Use - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T16:26:23+00:00\",\"dateModified\":\"2025-08-05T05:37:38+00:00\",\"description\":\"Master SQL CASE WHEN syntax & usage with examples. Learn conditional logic for smarter database queries.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL CASE WHEN: How to Use\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL CASE WHEN: How to Use - Blog - Silicon Cloud","description":"Master SQL CASE WHEN syntax & usage with examples. Learn conditional logic for smarter database queries.","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:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/","og_locale":"en_US","og_type":"article","og_title":"SQL CASE WHEN: How to Use","og_description":"Master SQL CASE WHEN syntax & usage with examples. Learn conditional logic for smarter database queries.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T16:26:23+00:00","article_modified_time":"2025-08-05T05:37:38+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"SQL CASE WHEN: How to Use","datePublished":"2024-03-14T16:26:23+00:00","dateModified":"2025-08-05T05:37:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/"},"wordCount":170,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["CASE Statement SQL","Conditional SQL","Database Querying","SQL CASE WHEN","sql tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/","name":"SQL CASE WHEN: How to Use - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T16:26:23+00:00","dateModified":"2025-08-05T05:37:38+00:00","description":"Master SQL CASE WHEN syntax & usage with examples. Learn conditional logic for smarter database queries.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-sql-case-when-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL CASE WHEN: How to Use"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12703"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12703\/revisions"}],"predecessor-version":[{"id":156528,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12703\/revisions\/156528"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}