The following table identifies equivalent ANSI SQL:2011 window functions for Teradata-specific functions.
The use of the Teradata-specific functions listed in the following table is strongly discouraged. These functions are retained only for backward compatibility with existing applications. Be sure to use the ANSI-compliant window functions for any new applications you develop.
| Teradata-Specific Functions | Equivalent ANSI SQL:2011 Window Functions |
|---|---|
| CSUM | SUM |
| MAVG | AVG |
| MDIFF(x, w, y) | Composable from SUM |
| MLINREG | Composable from SUM and COUNT |
| QUANTILE | Composable from RANK and COUNT |
| RANK | RANK |
| MSUM | SUM |