Difference between revisions of "NULL Operator"
Jump to navigation
Jump to search
(Created page with "If you need to identify records that have a NULL value, you must use the IS NULL comparison operator SELECT order#, shipdate FROM orders WHERE shipdate IS NULL; SELECT o...") |
(No difference)
|
Latest revision as of 19:58, 24 October 2017
If you need to identify records that have a NULL value, you must use the IS NULL comparison operator
SELECT order#, shipdate FROM orders WHERE shipdate IS NULL;
SELECT order#, shipdate FROM orders WHERE shipdate IS NOT NULL;