Case statement in SQL
In Salesforce Marketing Cloud (SFMC) , we can use the CASE statement in SQL (Query Activities in Automation Studio) to apply conditional logic—similar to IF-ELSE . 🔹 Basic Syntax CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE default_result END Source DE Target DE 1. Age Group Segmentation Query - SELECT FirstName, CASE WHEN Age < 18 THEN 'Minor' WHEN Age BETWEEN 18 AND 40 THEN 'Adult' ELSE 'Senior' END AS AgeGroup FROM Customer_master_Abu Query in SQL :- Target DE after query :- 2. Engagement Level Query in SQL - SELECT FirstName, CASE WHEN OpenCount > 10 THEN 'High' WHEN OpenCount BETWEEN 5 AND 10 THEN 'Medium' ELSE 'Low' END AS Engagement From Customer_master_Abu Query :- Target DE after query run :- 3. Greeting Query - SELECT FirstName, CASE...