| 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"
|