Basic operations
There are four basic operations
that we will learn about.
SELECT - retrieves data
INSERT - adds data
UPDATE - edits existing data
DELETE - removes data
Basic operators
The following operators can be
used in SQL:
Operator Description
= Equality
<> Non-equality
!= Non-equality
< Less than
<= Less than or equal to
!< Not less than
> Greater than
>= Greater than or equal to
!>Not greater than
BETWEEN Between two specified
values
IS NULL Is a NULL value |