Keyword reference

Keyword Action Page
ALL. Display duplicate rows ALL. -- Display duplicate rows
AND Present on two conditions AND -- Present on two conditions
AO., AO(n). Sort rows in ascending order AO., AO(n). -- Sort rows in ascending order
AVG. Calculate the average value AVG. -- Calculate the average value
BETWEEN x AND y Present values within a range BETWEEN x AND y -- Present values within a range
COUNT. Count the number of values in a column COUNT. -- Count the number of values in a column
D. Delete a row from a table D. -- Delete rows from a table
DO., DO(n). Sort rows in descending order DO., DO(n). -- Sort rows in descending order
G. Grouping G. -- Grouping data
I. Insert a row into a table I. -- Insert rows into a table
IN (x, y, z) Present certain values in a list IN (x,y,z) -- Present certain values in a set
LIKE Present on part of a value LIKE -- Present on part of a value
MAX. Calculate the maximum value MAX. -- Calculate the maximum value
MIN. Calculate the minimum value MIN. -- Calculate the minimum value
NOT Present the opposite condition NOT -- Present on the opposite of the condition
NULL Present rows with missing entries NULL -- Present rows with missing entries
OR Present either of two conditions OR -- Present on either of two conditions
P. Present information in a table P. -- Present data in a table
SUM. Calculate the sum SUM. -- Calculate the total
U. Update a row in a table U. -- Update a row in a table
UNQ. Eliminate duplicate rows UNQ. -- Eliminate duplicate rows
USER Present rows with a value of user ID USER -- Present rows with a value equal to a user identification
+ - * / Calculate arithmetic expressions +, -, *, / -- Calculated values
= ¬= > < Present on equality and inequality =, ¬=, , < -- Equality and inequality
[ Previous Page | Next Page | Contents | Index ]