Last Registration by date

Question

How do I return the latest update to a record example the record may have several status in one day but need to return the latest

Answer 1

To bring the highest time_end of each date use:

SELECT Ordem, Hora, MAX(hora_fim), status FROM sua_tabela
GROUP BY Hora
ORDER BY Hora;

select above will only work in Mysql if SQL mode ONLY_FULL_GROUP_BY is disabled.

Answer 2

SELECT * FROM Tabela
WHERE ordem = numero da orem
ORDER BY Hora DESC, horafim DESC
LIMIT 1;