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

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
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 from the attachment in the left sidebar.

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