DrSchool Learn coding, fast.
EN AR BN CS DE EL Search

Conditionals — Example 61

Quick explanation + ready code for: Conditionals.

SQL Conditionals Back to examples
Back to language
Syntax: Conditionals in SQL. ID: #61

Code

SELECT CASE WHEN 6%2=0 THEN 'even' ELSE 'odd' END AS parity;

Notes

You can copy this snippet and adapt it. For advanced, add real-world inputs, edge cases, and tests.