{"id":3941,"date":"2025-06-06T20:55:15","date_gmt":"2025-06-06T20:55:15","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=3941"},"modified":"2025-06-07T09:58:09","modified_gmt":"2025-06-07T09:58:09","slug":"sql-case","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/sql\/sql-case\/","title":{"rendered":"SQL CASE"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><code>CASE<\/code> lets you add <strong>if-else logic<\/strong> inside SQL statements. It\u2019s great for transforming data or creating new categorized columns.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd39 Basic Syntax (Simple CASE)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT\n  column,\n  CASE column\n    WHEN value1 THEN result1\n    WHEN value2 THEN result2\n    ELSE result_default\n  END AS alias_name\nFROM table_name;<\/code><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd39 Example: Classify Employees by Salary<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT\n  employee_name,\n  salary,\n  CASE\n    WHEN salary &gt;= 100000 THEN 'High'\n    WHEN salary &gt;= 50000 THEN 'Medium'\n    ELSE 'Low'\n  END AS salary_level\nFROM employees;<\/code><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd39 Searched CASE Syntax (More flexible)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT\n  column,\n  CASE\n    WHEN condition1 THEN result1\n    WHEN condition2 THEN result2\n    ELSE result_default\n  END AS alias_name\nFROM table_name;<\/code><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 Quick Recap<\/h2>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table><thead><tr><th>Concept<\/th><th>Explanation<\/th><\/tr><\/thead><tbody><tr><td><code>CASE<\/code><\/td><td>Adds conditional logic inside queries<\/td><\/tr><tr><td>Simple CASE<\/td><td>Compares a column to fixed values<\/td><\/tr><tr><td>Searched CASE<\/td><td>Uses conditions with WHEN<\/td><\/tr><tr><td>Returns<\/td><td>Values or expressions based on conditions<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705 Use <code>CASE<\/code> to create dynamic, condition-based outputs inside your queries<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CASE lets you add if-else logic inside SQL statements. It\u2019s great for transforming data or creating new categorized columns. \ud83d\udd39 Basic Syntax (Simple CASE) \ud83d\udd39 Example: Classify Employees by Salary \ud83d\udd39 Searched CASE Syntax (More flexible) \ud83e\udde0 Quick Recap Concept Explanation CASE Adds conditional logic inside queries Simple CASE Compares a column to fixed values [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3941","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}