I am trying to pull information from a table that has multiple dates. Let's say it was a table tracking what days people went to the gym. Every time the person scans his or her card, another row of data is created. Let's say I only wanted to pull in the most recent visit for each gym member and the field name for the date is contact_date.
I essentially want something like:
select Name, Contact_Date, Address from TABLE1
where contact_date = most recent date of all the visits that gym member has.
I need the code to tell teradata to pull in the most recent date.