if clause in sql code example

Example 1: if else sql

IF Boolean_expression
BEGIN
    -- Statement block executes when the Boolean expression is TRUE
END
ELSE
BEGIN
    -- Statement block executes when the Boolean expression is FALSE
END

Example 2: if in sql

SELECT 
  IF(500<1000, "YES", "NO");