{"id":94523,"date":"2020-09-16T11:00:00","date_gmt":"2020-09-16T08:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=94523"},"modified":"2022-02-24T11:45:42","modified_gmt":"2022-02-24T09:45:42","slug":"sql-case-statement-example","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-case-statement-example\/","title":{"rendered":"SQL CASE Statement Example"},"content":{"rendered":"

This example will focus on the SQL Case Statement.<\/p>\n

In any programming language, you would know that the control statements are the most essential part of the programming language. Just like if-else<\/strong> in any of the programming languages, SQL also has the control statements. <\/p>\n

1. About SQL CASE Statement <\/h2>\n

There will be a list of conditions, which can either be true or false. What the CASE<\/strong> statement does is that it goes through every condition one by one, and returns only the value for the first true statement. <\/p>\n

If there is no statement true, then it moves onto the else part. And, if even the else part is false, then it returns NULL<\/strong>. <\/p>\n

2. SQL CASE Syntax<\/h2>\n

The SQL CASE<\/strong> Syntax is given as follows: <\/p>\n

\n
\n
\n
\nSELECT CASE expr\nWHEN expr1 THEN X\nWhen expr2 THEN Y\n...\nELSE Z\nEND AS column_name\n<\/pre>\n<\/div>\n
Here, expr<\/strong>, expr1<\/strong>, and expr2 <\/strong>represent expressions (conditions), while X<\/strong>, Y<\/strong>, and Z<\/strong> represent the statements that need to be executed when their respective conditions are true. <\/p>\n
For example: if expr1<\/strong> is true, then X <\/strong>will be returned. If expr2<\/strong> is true, then Y<\/strong> will be returned. And, if-else is true, then Z<\/strong> will be returned. If none of the expressions\/conditions match to true, then NULL<\/strong> will be returned. <\/p>\n<\/div>\n<\/div>\n
Note:<\/strong><\/p>\n