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;
If the CASE expression is in a VALUES clause, an IN predicate, a GROUP BY clause, or an ORDER BY clause, the search-condition in a searched-when-clause cannot be a quantified predicate, IN predicate using a fullselect, or an EXISTS predicate (SQLSTATE 42625).
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.
A CASE expression allows an expression to be selected based on the evaluation of one or more conditions. CASE searched-when-clause simple-when-clause ELSE NULL ELSE result-expression END searched-when-clause:
Example 1: Use a simple case statement WHEN clause to update column DEPTNAME in table DEPT, depending on the value of SQL variable v_workdept. CASE v_workdept WHEN 'A00' THEN UPDATE DEPT SET DEPTNAME = 'DATA ACCESS 1'; WHEN 'B01' THEN UPDATE DEPT SET DEPTNAME = 'DATA ACCESS 2'; ELSE UPDATE DEPT SET DEPTNAME = 'DATA ACCESS 3'; END CASE
1 sty 2018 · The WHERE clause specifies the search condition for the rows returned by the SELECT statement. The following shows the syntax of the WHERE clause in the SELECT statement: SELECT select_list FROM table_name WHERE search_condition ORDER BY sort_expression; Code language: SQL (Structured Query Language) ( sql )
15 gru 2010 · I’m not clear on what you are trying to return in your select column list… I think you want either NULL or the field value. The CASE construct is not needed, in this case. Just use a predicate: select fieldValue from myTable where (fieldValue IS NULL) or (fieldValue = anotherValue)
