In SQL, I have three columns, the first two are values to create distinction for a person. The third column will have different values for each person (dates). How do I select the row for each person with the oldest valued date?

enter image description here

should output:
John Plumber 1/3/2020
Elizabeth Teacher 12/1/2020

  • 1
    Read about group by and aggregate functions.
    – mustaccio
    Jun 3, 2022 at 19:54

1 Answer 1

SELECT First Name, 
       MIN(Day of material)  
FROM table  
GROUP BY First Name, Job


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.