{"id":265,"date":"2024-08-23T02:21:10","date_gmt":"2024-08-23T02:21:10","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=265"},"modified":"2025-05-16T06:18:08","modified_gmt":"2025-05-16T06:18:08","slug":"sql-case","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-case\/","title":{"rendered":"SQL Case"},"content":{"rendered":"\n

The SQL Case statement is a useful command that allows you to perform conditional logic in SQL queries. It works similarly to if-else statements in programming languages that enables you to return different values based on specified conditions.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL Case Syntax<\/h2>\n\n\n\n
SELECT column_name,\n    CASE\n        WHEN condition1 THEN result1\n        WHEN condition2 THEN result2\n        ...\n        ELSE resultN\n    END AS new_column_name\nFROM table_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL Case Categorizing Patients by Appointment Status Example<\/h2>\n\n\n\n
This query joins the Patients table and the Appointments table, categorizing patients as “Active,” “Inactive,” or “Unknown” based on the appointment status.<\/p>\n\n\n\n
SELECT p.first_name, p.last_name,\n    CASE\n        WHEN a.status = 'Scheduled' THEN 'Active Patient'\n        WHEN a.status = 'Completed' THEN 'Inactive Patient'\n        ELSE 'Unknown Status'\n    END AS patient_status\nFROM Patients p\nJOIN Appointments a ON p.patient_id = a.patient_id;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL Case Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL Case Labs<\/h2>\n\n\n\n