{"id":12707,"date":"2024-03-14T16:27:05","date_gmt":"2024-03-14T16:27:05","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/"},"modified":"2025-08-05T05:40:34","modified_gmt":"2025-08-05T05:40:34","slug":"usage-of-case-when-in-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/","title":{"rendered":"SQL CASE WHEN Explained: Syntax & Examples"},"content":{"rendered":"

In SQL, the CASE WHEN statement is a conditional expression used to return different results based on specified conditions. The basic syntax is as follows:<\/p>\n

CASE WHEN condition1 THEN result1\r\n     WHEN condition2 THEN result2\r\n     ...\r\n     ELSE resultN\r\nEND\r\n<\/code><\/pre>\n
condition1 and condition2 are the criteria to be evaluated, while result1 and result2 are the outcomes returned when their corresponding criteria are met. The ELSE clause is optional and is used to specify the default result when none of the conditions are satisfied.<\/p>\n
The CASE WHEN statement can be nested and can return different results based on different conditions. For example:<\/p>\n
CASE WHEN condition1 THEN result1\r\n     WHEN condition2 THEN \r\n        CASE WHEN condition3 THEN result3\r\n             ELSE result4\r\n        END\r\n     ELSE result2\r\nEND\r\n<\/code><\/pre>\n
When using the CASE WHEN statement, there are several points to keep in mind:<\/p>\n
    \n
  1. The conditional expression can be a simple comparison operator or a complex logical expression.<\/li>\n
  2. The result can be a constant, an expression, a column name, etc.<\/li>\n
  3. The CASE WHEN statement can be used in columns, WHERE clauses, ORDER BY clauses, etc. within SELECT statements.<\/li>\n
  4. The CASE WHEN statement evaluates conditions in the order they are written, returning the corresponding result once a condition is met without evaluating any subsequent conditions.<\/li>\n<\/ol>\n
    The CASE WHEN statement is a commonly used conditional expression in SQL, allowing different results to be returned based on different conditions, making SQL queries more flexible and targeted.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In SQL, the CASE WHEN statement is a conditional expression used to return different results based on specified conditions. The basic syntax is as follows: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 … ELSE resultN END condition1 and condition2 are the criteria to be evaluated, while result1 and result2 are the outcomes returned […]<\/p>\n","protected":false},"author":6,"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,16700,4367,1845,569],"class_list":["post-12707","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-case-statement-sql","tag-sql-case-when","tag-sql-conditional-logic","tag-sql-queries","tag-sql-tutorial"],"yoast_head":"\nSQL CASE WHEN Explained: Syntax & Examples - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.\" \/>\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\/usage-of-case-when-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL CASE WHEN Explained: Syntax & Examples\" \/>\n<meta property=\"og:description\" content=\"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-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:27:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T05:40:34+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\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=\"Benjamin Taylor\" \/>\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\/usage-of-case-when-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"SQL CASE WHEN Explained: Syntax & Examples\",\"datePublished\":\"2024-03-14T16:27:05+00:00\",\"dateModified\":\"2025-08-05T05:40:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/\"},\"wordCount\":205,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"CASE Statement SQL\",\"SQL CASE WHEN\",\"SQL conditional logic\",\"SQL Queries\",\"sql tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/\",\"name\":\"SQL CASE WHEN Explained: Syntax & Examples - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T16:27:05+00:00\",\"dateModified\":\"2025-08-05T05:40:34+00:00\",\"description\":\"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL CASE WHEN Explained: Syntax & Examples\"}]},{\"@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\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL CASE WHEN Explained: Syntax & Examples - Blog - Silicon Cloud","description":"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.","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\/usage-of-case-when-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"SQL CASE WHEN Explained: Syntax & Examples","og_description":"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.","og_url":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T16:27:05+00:00","article_modified_time":"2025-08-05T05:40:34+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"SQL CASE WHEN Explained: Syntax & Examples","datePublished":"2024-03-14T16:27:05+00:00","dateModified":"2025-08-05T05:40:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/"},"wordCount":205,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["CASE Statement SQL","SQL CASE WHEN","SQL conditional logic","SQL Queries","sql tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/","url":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/","name":"SQL CASE WHEN Explained: Syntax & Examples - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T16:27:05+00:00","dateModified":"2025-08-05T05:40:34+00:00","description":"Master SQL's CASE WHEN statement for conditional logic. Syntax, examples, and best practices included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/usage-of-case-when-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL CASE WHEN Explained: Syntax & Examples"}]},{"@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\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12707","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12707"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12707\/revisions"}],"predecessor-version":[{"id":156532,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12707\/revisions\/156532"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}