Expression | Description |
---|---|
'Test Tech' | Character string literal |
1024 | Numeric literal |
Employee.FirstName | Column name |
Salary * 12 + 100 | Arithmetic expression producing a numeric value |
INTERVAL '10' MONTH * 4 | Interval expression producing an interval value |
CURRENT_DATE + INTERVAL '2' DAY | DateTime expression producing a DATE value |
CURRENT_TIME - INTERVAL '1' HOUR | DateTime expression producing a TIME value |
'Last' || ' Order' | String expression producing a character string value |
CASE x WHEN 1 THEN 1001 ELSE 1002 END |
Valued CASE conditional expression producing a numeric value |