TurboSQL Guide

Data Manipulation Language

Previous  Top  Next

TurboSQL includes the following commands, 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.

Sub-Queries

Comparisons to the result of a different query with IN, ANY, SOME, ALL and EXISTS.

Functions, Predicates and Operators

General Functions and Operators

Calculations and comparisons with numbers, strings, timestamps etc.

Arithmetic Functions and Operators

Calculations with numbers

String Functions and Operators

Calculations with strings

Date and Time Functions and Operators

Calculations with date and time

Aggregation Functions

Statistics

Miscellaneous Functions and Operators

Calculations that do not fit in one of the other categories

Table operators

Combine two table into a new one

Sub-Queries

Compare rows with the result of another query

Full-Text Search

Searching for arbitrary keywords anywhere in a row.