Data Manipulation Language
Previous  Top  Next


Turbo SQL includes the following statements, clauses, functions and predicates for the DML:

Statements
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.