{"id":12859,"date":"2024-03-14T16:44:29","date_gmt":"2024-03-14T16:44:29","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/"},"modified":"2025-08-05T07:57:29","modified_gmt":"2025-08-05T07:57:29","slug":"how-is-the-when-clause-used-in-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/","title":{"rendered":"SQL WHEN Clause: A Complete Guide"},"content":{"rendered":"<p>In SQL, WHEN is part of the CASE expression and is used to specify the condition for each CASE clause. Following WHEN must be a condition expression that indicates when the clause should be executed.<\/p>\n<p>WHEN clauses are usually used together with CASE structures to perform different operations based on various conditions. Here is how to use WHEN:<\/p>\n<ol>\n<li>WHAT TIME<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1,\r\n       <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> <span class=\"hljs-keyword\">AS<\/span> result_column\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name;\r\n<\/code><\/pre>\n<p>In the example above, different operations are executed and corresponding result columns are returned based on different conditions (condition1, condition2, etc).<\/p>\n<ol>\n<li>WHENEVER<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1,\r\n       <span class=\"hljs-keyword\">CASE<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> condition1 <span class=\"hljs-keyword\">AND<\/span> condition2 <span class=\"hljs-keyword\">THEN<\/span> result1\r\n           <span class=\"hljs-keyword\">WHEN<\/span> condition3 <span class=\"hljs-keyword\">OR<\/span> condition4 <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> <span class=\"hljs-keyword\">AS<\/span> result_column\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name;\r\n<\/code><\/pre>\n<p>In the example above, multiple conditions can be combined using logical operators (such as AND, OR) to execute corresponding operations based on complex conditions.<\/p>\n<p>It is important to note that the order of the WHEN clauses is crucial, as the CASE expression will check each WHEN clause from top to bottom and execute the first one that meets the condition. If no conditions are true, the operation in the ELSE clause will be executed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL, WHEN is part of the CASE expression and is used to specify the condition for each CASE clause. Following WHEN must be a condition expression that indicates when the clause should be executed. WHEN clauses are usually used together with CASE structures to perform different operations based on various conditions. Here is how [&hellip;]<\/p>\n","protected":false},"author":10,"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":[9656,15838,97,125,16946],"class_list":["post-12859","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-case-statement","tag-conditional-expressions","tag-database-query","tag-sql","tag-when-clause"],"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 WHEN Clause: A Complete Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.\" \/>\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-is-the-when-clause-used-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL WHEN Clause: A Complete Guide\" \/>\n<meta property=\"og:description\" content=\"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\" \/>\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:44:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T07:57:29+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-is-the-when-clause-used-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"SQL WHEN Clause: A Complete Guide\",\"datePublished\":\"2024-03-14T16:44:29+00:00\",\"dateModified\":\"2025-08-05T07:57:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\"},\"wordCount\":162,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"CASE statement\",\"conditional expressions\",\"database query\",\"SQL\",\"WHEN clause\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\",\"name\":\"SQL WHEN Clause: A Complete Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T16:44:29+00:00\",\"dateModified\":\"2025-08-05T07:57:29+00:00\",\"description\":\"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL WHEN Clause: A Complete Guide\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL WHEN Clause: A Complete Guide - Blog - Silicon Cloud","description":"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.","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-is-the-when-clause-used-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"SQL WHEN Clause: A Complete Guide","og_description":"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T16:44:29+00:00","article_modified_time":"2025-08-05T07:57:29+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"SQL WHEN Clause: A Complete Guide","datePublished":"2024-03-14T16:44:29+00:00","dateModified":"2025-08-05T07:57:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/"},"wordCount":162,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["CASE statement","conditional expressions","database query","SQL","WHEN clause"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/","name":"SQL WHEN Clause: A Complete Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T16:44:29+00:00","dateModified":"2025-08-05T07:57:29+00:00","description":"Complete guide to using WHEN clauses in SQL CASE expressions. Learn conditional logic with practical examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-when-clause-used-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL WHEN Clause: A Complete Guide"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12859","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12859"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12859\/revisions"}],"predecessor-version":[{"id":156701,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12859\/revisions\/156701"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}