My table in MySQL 8.0.29 looks like this

I'm trying to get the latest appointment for every person with the names in descending order

The query should return

I've tried

SELECT * FROM (SELECT * FROM Table ORDER BY Appointment DESC) AS temp GROUP BY Name ORDER BY Name DESC;

But it doesn't return the latest dates for each person

CodePudding user response：

You should select the max appointment date for each person:

SELECT   name, MAX(appointment)
FROM     mytable
GROUP BY name
ORDER BY name DESC

CodePudding user response：

You can use GROUP By

SELECT NAme, MAX(Appointment) FROM mytable GROUP BY Name

Or otu can use Window functions

SELECT Name,Appointment
FROM (
SELECT Name, Appointment, ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Appointment DESC) rn) t1
WHERE rn = 1