Link to home
Start Free TrialLog in
Avatar of 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.
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial