Sample Header Ad - 728x90

choosing oldest valued cell when 2 columns have same value but third column has differing values (SQL)

-4 votes
1 answer
470 views
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
Asked by mcsmithums (9 rep)
Jun 3, 2022, 07:27 PM
Last activity: Jul 9, 2025, 02:40 PM