hello, i try to get a result of deleting duplicate data with most recently
i have fields named, l,m,s,state, date1
id l m s state date1 1 me un 3 n 2021-04-02 1:05:33 PM 1 me un 3 y 2021-04-02 1:09:33 PM
i attached image below. which i hope to get this result
i want to know the sql statement, is it possible?