oracle - SQL select case when clause - Stack Overflow
I think the alias should come after the case statement in Oracle. Try this, SELECT * , CASE WHEN ListPrice = 0 THEN 'Mfg item - not for resale' WHEN ListPrice < 50 THEN 'Under $50' WHEN ListPrice >= 50 and ListPrice < 250 ......