akatz66
asked on
Teradata most recent date
Hi All,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.