| 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 |