View Single Post
  #1   Report Post  
billybob1
 
Posts: n/a
Default How to find the minimum value in a database with multiple values .

I am trying to find the earliest transaction date for a program participant
with multiple records relating to each participant. For example in a list of
transactions participants are identified by their SSN, there are many
transactions by each participant with the date of each transaction recorded.
I want to find the earliest transaction date by each participant without
sorting the database.