Selecting rows with max value?

Question

MySQL

You need to get all the rows in which the date will be the maximum, with the same Post_id and Status

Please tell me how this can be done, I tried to do it in various ways, but nothing comes out.

Answer 1

Grouping by specified fields and maximum date. If you also need a code, then link the result to the main table by the specified fields and date.