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:
http://img189.imageshack.us/img189/6872/26352213.png
How can i query those results to obtain this:
http://img249.imageshack.us/img249/8498/10059621.png
Please, be aware that i would like the last report ID, not the last date. Can anyone help me out?
Best Regards