PowerCenter
All Products
Operator
| IBM DB2
| Microsoft SQL Server
| Oracle
| PostgreSQL
| SAP HANA
| Sybase ASE
|
---|---|---|---|---|---|---|
+ - * /
| X
| X
| X
| X
| X
| X
|
%
| X
| X
| X
| X
| X
| X
|
||
| S
| S
| X
| X
| X
| S
|
= > < >= <= <>
| X
| X
| X
| X
| X
| X
|
!=
| X
| X
| X
| X
| X
| X
|
^=
| X
| X
| X
| X
| X
| X
|
not and or
| X
| X
| X
| X
| X
| X
|
Operator
| Greenplum
| Netezza
| Teradata
| Vertica
|
---|---|---|---|---|
+ - * /
| X
| X
| X
| X
|
%
| -
| X
| X
| X
|
||
| X
| X
| S
| X
|
= > < >= <= <>
| X
| X
| X
| X
|
!=
| X
| X
| X
| X
|
^=
| X
| X
| X
| X
|
not and or
| X
| X
| X
| X
|
Operator
| Amazon Redshift
| Azure DW
| Google BigQuery
| Snowflake
|
---|---|---|---|---|
%
| X
| X
| X
| X
|
||
| X
| S
| X
| X
|
= > < >= <= <>
| S
| X
| X
| X
|
!=
| S
| X
| X
| X
|
^=
| S
| X
| X
| X
|
not and or
| S
| X
| X
| X
|
Updated August 27, 2020