-4

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

Improve this question
1
  • 1
    Read about group by and aggregate functions. Commented Jun 3, 2022 at 19:54

1 Answer 1

Reset to default
1 
SELECT First Name, Job, MIN(Day of material) FROM table GROUP BY First Name, Job
Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.