Example:
-------- WHERE sal NOT BETWEEN 1000 AND 3000
-------- WHERE ename NOT LIKE '%K%'
-------- WHERE comm IS NOT NULL
The above example displays the name,job of employee whose job is not MANAGER or ANALYST.
Note:
The NOT operator can also be used with other SQL operators, such as BETWEEN, LIKE and NULL-------- WHERE sal NOT BETWEEN 1000 AND 3000
-------- WHERE ename NOT LIKE '%K%'
-------- WHERE comm IS NOT NULL
No comments:
Post a Comment