Turbo SQL includes the following commands, clauses, functions and predicates for the DML:
Commands DELETE Deletes one or more rows from a table.
INSERT Inserts one or more rows into a table.
SELECT Retrieves data from tables.
UPDATE Modifies one or more existing rows in a table.
Clauses FROM Specifies the tables from which a SELECT statement retrieves data. GROUP BY Combines rows with column values in common into single rows.
HAVING Specifies filtering conditions for a SELECT statement.
ORDER BY Sorts the rows retrieved by a SELECT statement.
WHERE Specifies filtering conditions for a SELECT, UPDATE or DELETE statement.
Functions
Concatenation Concatenates two string values. LOWER Forces a string to lowercase.
UPPER Forces a string to uppercase.
SUBSTRING Extracts a portion of a string value.
TRIM Removes repetitions of a specified character from the left, right, or both sides of a string.
AVG Averages all non-NULL numeric values in a column.
COUNT Counts the number of rows in a result set.
MAX Determines the maximum value in a column.
MIN Determines the minimum value in a column.
SUM Totals all numeric values in a column.
CAST Converts values from one data type to another. Not yet supported.
EXTRACT Extracts the year, month, or day field of a date.
Operators
Arithmetic + - * /
Logical AND OR NOT
Predicates
Comparison Compares two values.
BETWEEN Compares a value to a range formed by two values.
EXISTS Determines whether a value exists in a look-up table.
IN Determines whether a value exists in a list of values or a table.
LIKE Compares, in part or in whole, one value with another.
IS NULL Compares a value with an empty, or NULL, value. Not yet supported.
SOME/ANY/ALL Performs quantified comparisons. Not yet supported.