Hi there! I´m with some difficult to do this query. I have this:
SELECT IDReport AS [ID Report], IDHardware AS [ID Hardware], DataHoraReport AS [Último Report], Versao AS Versão, DataInstalacao AS Instalação, DataUltimaActualizacao AS [Última Actualização] FROM Report
in which result this:
How can i query those results to obtain this:
Please, be aware that i would like the last report ID, not the last date. Can anyone help me out?