Skip to Main Content

IF/THEN logic with CASE expressions in SQL

Conditional IF-THEN logic is a foundational concept in programming. But there's no IF statement in SQL! To do conditional logic in SQL, you use CASE expressions. Join this session to learn how to use CASE in * SELECT & WHERE clauses * Aggregate and window functions * PL/SQL code

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 22 August 2023
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions