| Advance Analytical Functions | Snowflake | AWS Redshift | Google Bigquery | Databricks | Oracle | Exasol |
|---|---|---|---|---|---|---|
| MATCH_RECOGNIZE | ✅ | ❌ | ❌ | ❌ | ✅ | ❌ |
| QUALIFY | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| SKYLINE | ❌ | ❌ | ❌ | ❌ | ❌ | ✅ |
| GRAPH_TABLE | ❌ | ❌ | ❌ | ❌ | ✅ | ❌ |
| MIN_BY / MAX_BY | ✅ | ❌ | ✅ | ✅ | ❌ | ❌ |
| GROUP BY CUBE | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
| GROUP BY ROLLUP | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
| GROUP BY GROUPING SETS | ✅ | ❌ | ✅ | ✅ | ✅ | ✅ |
| CONDITIONAL_TRUE_EVENT | ✅ | ❌ | ❌ | ❌ | ❌ | ❌ |
| CONDITIONAL_CHANGE_EVENT | ✅ | ❌ | ❌ | ❌ | ❌ | ❌ |
| IS DISTINCT FROM / IS NOT DISTINCT FROM | ✅ | ❌ | ✅ | ✅ | ❌ | ❌ |