TurboSQL Guide Data Manipulation Language 
Previous Top Next 
TurboSQL includes the following commands, clauses, functions and predicates for the DML:
Statements
Deletes one or more rows from a table. 

Inserts one or more rows into a table. 

Retrieves data from tables. 

Modifies one or more existing rows in a table. 
Clauses
Specifies the tables from which a SELECT statement retrieves data. 

Combines rows with column values in common into single rows. 

Specifies filtering conditions for a SELECT statement. 

Sorts the rows retrieved by a SELECT statement. 

Specifies filtering conditions for a SELECT, UPDATE or DELETE statement. 

Comparisons to the result of a different query with IN, ANY, SOME, ALL and EXISTS. 
Functions, Predicates and Operators
Calculations and comparisons with numbers, strings, timestamps etc. 

Calculations with numbers 

Calculations with strings 

Calculations with date and time 

Statistics 

Calculations that do not fit in one of the other categories 

Combine two table into a new one 

Compare rows with the result of another query 

Searching for arbitrary keywords anywhere in a row. 