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 |