SQL NULL Example :
|
In this query , "SMITH' won't be printed, as the clause "NOT NULL,
would mask the column originally, NULL.
Please Also review the example with NULL Note for any conflicting or competing clauses. |
EMP Table: |
Oracle:
In the output SMITH , row was dropped.
|
PostgreSQL
In the out put the row "SMITH" was not printed.
|