I need to write a mysql query that returns all columns, but only 1 of each set of identifying columns. i.e.

I have a table with a primary key on 3 fields (firstName, lastName, effDate). I can have x amount of rows with the same firstName and lastName but all have different effDates. I've included an example set of data below. I need to write a query that returns the most recent firstName + lastName combination. Is this possible? something like:

SELECT DISTINCT(firstName, lastName), * FROM table ORDER BY effData DESC;

example data:

FirstName lastName effDate

Will Johnson 2021-02-02

Will Johnson 2021-03-02

Will Johnson 2021-04-02

Sam Red 2021-02-23

Sam Red 2021-04-28

example return:

FirstName lastName effDate

Will Johnson 2021-04-02

Sam Red 2021-04-28