Search results
3 lis 2018 · SELECT BIRTHDATE FROM SAMPLE_TABLE. WHERE. (CASE. WHEN (:from AND NOT :to) THEN BIRTHDATE >= :receivefrom. WHEN (:to AND NOT :from) THEN BIRTHDATE <= :to. WHEN (:to AND :from) THEN BIRTHDATE BETWEEN :from AND :to.
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.
Example 1 (simple-when-clause): Assume that in the EMPLOYEE table the first character of a department number represents the division in the organization. Use a CASE expression to list the full name of the division to which each employee belongs.
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.
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 · This example uses the LIKE operator in the WHERE clause to find books whose title contains the string 'SQL': SELECT title, total_pages, rating, published_date FROM books WHERE title LIKE '%SQL%' ORDER BY title; Code language: SQL (Structured Query Language) ( sql )
24 cze 2019 · You may use the following syntax trick: CASE WHEN 'Value' IN (TB1.ColumnX, TB1.ColumnY, TB1.ColumnZ) THEN Statement1 ELSE ' ' END AS MyColumn. The alternative to this would be to repeat the full equality check for each column: SELECT. CASE. WHEN TB1.ColumnX = 'Value' OR. TB1.ColumnY = 'Value' OR. TB1.ColumnZ = 'Value'.
