Case Summary The CASE statement chooses from a sequence of conditions, and executes a corresponding statement. Syntax CASE (WHEN <logical expression> THEN <arithmetic expression>) [ELSE &...

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:   […]

Use xSQL to Query Tables Developers, users, and programs can interact with Connect Data Services using Xactly’s implementation of the SQL-92 specification. NOTE: While Connect does not support a...