Avatar of akatz66
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.
Enterprise Software

Avatar of undefined
Last Comment
Sharath S

8/22/2022 - Mon
Sharath S

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.