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_WhichMax InputTable: titanic_dataset
passenger survived pclass gender age sibsp parch fare cabin embarked
--------- -------- ------ ------ --- ----- ----- ------- ----- --------
1 0 3 male 22 1 0 7.25 null S
2 1 1 female 38 1 0 71.28 C85 C
3 1 3 female 26 0 0 7.93 null S
4 1 1 female 35 1 0 53.10 C123 S
5 0 3 male 35 0 0 8.05 null S
Example: TD_WhichMax SQL Call for Maximum Fare
SELECT * FROM TD_WhichMax (
ON titanic_dataset AS InputTable
USING
TargetColumn ('fare')
) AS dt;
TD_WhichMax Output for Maximum Fare
passenger survived pclass gender age sibsp parch fare cabin embarked
--------- -------- ------ ------ --- ----- ----- ------- ----- --------
2 1 1 female 38 1 0 71.28 C85 C