if else sql code example
Example 1: else if sql server
IF (Expression 1)
BEGIN
Statement 1;
END
ELSE IF (Expression 2)
BEGIN
Statement 2;
END
..........
ELSE
BEGIN
Default Statement;
END
Example 2: sql if else
BEGIN
IF my_val = 1 THEN [...]
ELSE [...]
END IF;
END;
SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result
FROM DUAL;
Example 3: if else sql
IF Boolean_expression
BEGIN
END
ELSE
BEGIN
END
Example 4: t-sql if else
IF 1=1
SELECT 1
ELSE
SELECT 0
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]
Example 5: SQL IF ELSE
SELECT CASE
WHEN A + B > C AND B + C > A AND A + C > B THEN
CASE
WHEN A = B AND B = C THEN 'Equilateral'
WHEN A = B OR B = C OR A = C THEN 'Isosceles'
ELSE 'Scalene'
END
ELSE 'Not A Triangle'
END
FROM TRIANGLES;