Essential Books

Selecting with CASE

suggest change

When results need to have some logic applied ‘on the fly’ one can use CASE statement to implement it. 

SELECT CASE WHEN Col1 < 50 THEN 'under' ELSE 'over' END threshold
FROM TableName

also can be chained 

SELECT 
    CASE WHEN Col1 < 50 THEN 'under' 
         WHEN Col1 > 50 AND Col1 <100 THEN 'between' 
         ELSE 'over' 
    END threshold
FROM TableName

one also can have CASE inside another CASE statement 

SELECT 
    CASE WHEN Col1 < 50 THEN 'under' 
         ELSE 
            CASE WHEN Col1 > 50 AND Col1 <100 THEN Col1 
            ELSE 'over' END 
    END threshold
FROM TableName
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
*SELECT
*Using the wildcard character to select all columns in a query.
*SELECT Using Column Aliases
*Select Individual Columns
*Selecting specified number of records
*Selecting with Condition
*Selecting with CASE
*Select columns which are named after reserved keywords
*Selecting with table alias
*Selecting with more than 1 condition.
*Selecting with Aggregate functions
*Get aggregated result for row groups
*Selection with sorted Results
*Selecting without Locking the table
*Select with condition of multiple values from column
*Select distinct unique values only
*Selecting with null
*Select rows from multiple tables
Table Of Contents