Ravindra BagaleCourses & study guides Track your progress

CASE WHEN: If-Then Logic in SQL

By Last updated:

Lessons in this chapter:

  1. 8.1 Why CASE WHEN Beats Manual Labels in Excel
  2. 8.2 How to Write Simple CASE WHEN … THEN … ELSE
  3. 8.3 How to Bucket Amounts (Small / Medium / Large)
  4. 8.4 CASE Inside ORDER BY (Custom Sort Order)
  5. 8.5 Practice: Ticket Priority and Order Size Labels

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

CASE WHEN is SQL's IF. Reports need simple labels like Small or Large, not only raw amounts.Revision cardWhat is CASE WHEN? CASE WHEN is SQL's IF. It picks a result based on conditions and finishes with the word END.Interview cardCASE vs WHERE. WHERE decides which rows appear in the result. CASE adds a label or a new value to the rows you keep.Comparison card

All cards for this chapter