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_WhichMin 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_WhichMin SQL Call for Minimum Fare
SELECT * FROM TD_WhichMin (
ON titanic_dataset AS InputTable
USING
TargetColumn ('fare')
) AS dt;
TD_WhichMin Output for Minimum Fare
passenger survived pclass gender age sibsp parch fare cabin embarked
--------- -------- ------ ------ --- ----- ----- --------- ----- --------
1 0 3 male 22 1 0 7.25 null S
The output shows the row that has the lowest value in the fare column.