EDIT SQL line commands can be specified with a repetition factor, n. Block commands are not valid.
SQL Line Command | Description |
|---|---|
D (Delete) | Deletes the current line. |
Dn | Deletes the current line plus n subsequent lines. |
I (Insert) | Inserts a line after the current line. |
In | Inserts n number of lines following the current line. |
R (Repeat) | Repeats the current line. |
Rn | Repeats the current line for n number of lines. |
Relational operators
Relational Operators | Description |
|---|---|
> | is greater than |
< | is less than |
= | is equal to |
¬= or <> | is not equal to |
>= | is greater than or equal to |
<= | is less than or equal to |
¬> | is not greater than |
¬< | is not less than |
IS NULL | has a null value |
LIKE | searches for a pattern |
IN | in a list of values |
BETWEEN | within a range of values |
AND is implied as the logical operator between columns. Specify OR to override the implied AND. Use NOT to negate IS NULL, LIKE, IN, and BETWEEN operators.
