NULL
The NULL predicate finds all rows where the value in the selected column is null.
SELECT (PaperType)
FROM PAPERS
WHERE Size11Price IS NULL ;
SELECT (PaperType)
FROM PAPERS
WHERE Size11Price IS NOT NULL ;The NULL predicate finds all rows where the value in the selected column is null.
SELECT (PaperType)
FROM PAPERS
WHERE Size11Price IS NULL ;
SELECT (PaperType)
FROM PAPERS
WHERE Size11Price IS NOT NULL ;