Search results
28 sie 2014 · select (case when someid = '1' then date_1 when someid = '2' then date_2 when someid = '3' then date_3 when someid = '4' then date_4 end), . . . from mytable;
SELECT EMPNO, WORKDEPT, SALARY+COMM FROM EMPLOYEE WHERE (CASE WHEN SALARY=0 THEN NULL ELSE COMM/SALARY END) > 0.25; The following CASE expressions are the same: SELECT LASTNAME, CASE WHEN LASTNAME = 'Haas' THEN 'President' ... SELECT LASTNAME, CASE LASTNAME WHEN 'Haas' THEN 'President' ...
Example 1: The following example shows how to do this using the syntax for a simple-case-statement-when-clause: CASE v_workdept WHEN 'A00' THEN UPDATE department SET deptname = 'DATA ACCESS 1'; WHEN 'B01' THEN UPDATE department SET deptname = 'DATA ACCESS 2'; ELSE UPDATE department SET deptname = 'DATA ACCESS 3'; END CASE
Use a CASE expression to list the full name of the division to which each employee belongs. SELECT EMPNO, LASTNAME, CASE SUBSTR(WORKDEPT,1,1) WHEN 'A' THEN 'Administration' WHEN 'B' THEN 'Human Resources' WHEN 'C' THEN 'Design' WHEN 'D' THEN 'Operations' END.
Introduction to Db2 CASE expression. A CASE expression allows you to select an expression based on evaluation of one or more conditions. In other words, it allows you to add the if-else logic to your queries. Db2 supports two kinds of CASE expressions: simple CASE and searched CASE expressions. Both simple and searched CASE are expressions ...
The CASE statement goes through conditions and returns a value when the first condition is met (like an COBOL Evaluate statement). So, If a condition is true, it will stop reading and return the result.
CASE statement. The SQL CASE statement is a conditional statement. The CASE statement works like a simple IF-THEN-ELSE statement. It test multiple condition and return a value when the first condition is satisfied. CASE syntax CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END
