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;
COALESCE (e1,e2,...,eN) CASE WHEN c1=var1 OR (c1 IS NULL AND var1 IS NULL) THEN 'a' WHEN c1=var2 OR (c1 IS NULL AND var2 IS NULL) THEN 'b' ELSE NULL END. DECODE (c1,var1, 'a', var2, 'b') CASE expressions allow an expression to be selected based on the evaluation of one or more conditions.
In the first query, Db2 performs the division before performing the CASE statement and an error occurs along with the results. SELECT REF_ID,PAYMT_PAST_DUE_CT, CASE WHEN PAYMT_PAST_DUE_CT=0 THEN 0 WHEN PAYMT_PAST_DUE_CT>0 THEN SUM(BAL_AMT/PAYMT_PAST_DUE_CT) END FROM PAY_TABLE GROUP BY REF_ID,PAYMT_PAST_DUE_CT;
Db2 supports two kinds of CASE expressions: simple CASE and searched CASE expressions. Both simple and searched CASE are expressions, therefore, you can use them in any clause that accepts an expression such as SELECT, WHERE, GROUP BY, and HAVING clauses.
Use a searched case statement WHEN clause to update column DEPTNAME in table DEPT, depending on the value of SQL variable . The CASE statement selects an execution path based on the evaluation of one or more conditions. A CASE statement operates in the same way as a CASE expression.
11 lut 2016 · I am using a CASE expression in my WHERE clause like this: SELECT * FROM ASPECT.WR_AM_ADT_SUMM INNER JOIN ASPECT.WR_AM_DLR_DTL ON AS_CNTRY_CD = DD_CNTRY_CD AND AS_DLR_CD = DD_...
10 mar 2010 · The CASE operation is common to several programming languages on the IBM i. This includes SQL in DB2 for i, where it is available as the CASE statement for use in conjunction with a SELECT statement, or CASE expression for use in conjunction with the DB2 for i SQL Procedure Language.
