Conditional Logic with CASE

Snippet

Conditional Logic with CASE

The CASE expression allows you to add conditional logic to your SQL queries. It evaluates conditions and returns a value when the first condition is met (like an if-then-else statement).

snippet.sql
sql
SELECT product_name,
  CASE 
    WHEN stock_count > 100 THEN 'High Stock'
    WHEN stock_count > 0 THEN 'Low Stock'
    ELSE 'Out of Stock'
  END AS inventory_status
FROM warehouse;

Breakdown

CASE

Starts the conditional block.

WHEN stock_count > 100 THEN 'High Stock'

Checks the first condition; if true, returns the specified string.

ELSE 'Out of Stock'

Provides a default value if none of the previous conditions were met.

END AS inventory_status

Closes the CASE block and assigns an alias to the resulting column.

Previous snippet Next snippet

From your library

Conditional Logic with CASE

Related