Column value predicate
Syntax
column-name comparison-op constant-expression
Parameters
column-name |
A single column of one the tables specified in the FROM Clause. |
comparison-op |
|
constant-expression |
A constant value of the same data type as the column-name. |
Notes
To check a column value for NULL
, use the NULL predicate.
Examples
table.column1 = 2 table.column2 = 'Seafood' table.column3 IS NULL