I need an sql that, in the table below, always brings the last insert for each user. I tried with distinct but it did not work. So in the case below sql would bring the results of line 2 and 5. Detail that there are more columns (city, country, address, etc ...) and that need to appear in the final result.
DATA----------------------ID---NOME
2017-07-17 16:37:38 || 1 || Lucas
2017-07-17 16:38:03 || 1 || Lucas
2017-07-17 16:38:37 || 2 || Juliana
2017-07-17 16:38:47 || 2 || Juliana
2017-07-17 16:39:00 || 2 || Juliana
After so much searching I found nothing. This table will have more insertions with different users (always 1 id for each user) but only exemplified to understand.