troubleshooting Question

Teradata most recent date

Avatar of akatz66
akatz66 asked on
Enterprise Software
1 Comment1 Solution944 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros