TD_RoundColumns Example | RoundColumns | Teradata Vantage - Example: How to Use TD_RoundColumns - Teradata Vantage

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file (SQLE-Analytic-Functions-Examples_xxxx) from the attachment in the left pane.

TD_RoundColumns InputTable: titanic

passenger pclass  fare      survived 
--------- ------  --------- -------- 
        1      3   7.25           0
        2      1  71.2833         1
        3      3   7.925          1
        4      1  53.100          1
        5      3   8.050          0

TD_RoundColumns SQL Call

SELECT * FROM TD_RoundColumns (
  ON titanic AS InputTable
  USING
  TargetColumns ('Fare')
  PrecisionDigit (1)
  Accumulate ('[0:1]','Survived')
) AS dt;

TD_RoundColumns Output

passenger pclass survived  fare      
--------- ------ --------  --------- 
        1      3        0      7.30
        2      1        1     71.30
        3      3        1      7.90
        4      1        1     53.10
        5      3        0      8.10