IF-THEN-ELSE Summary The IF-THEN-ELSE statement provides an alternative syntax to the CASE statement. Syntax IF <logical expression> THEN <arithmetic expression> [ELSE <arithmetic exp...

Use conditional expressions to perform different computations or actions based on whether a boolean condition evaluates to true or false. To use conditional expressions within Connect’s xSQL stateme...

DELETE removes rows from tables. Use DELETE with WHERE to remove all rows that contain a matching field value. First, let’s see how many rows are in the table:   […]