Doubt with SELECT in MYSQL database

Question

I need an sql that, in the table below, always bring the last insert to each user. I tried with distinct but it didn’t work. So in the case below sql would bring the results of row 2 and 5. Detail that there are more columns (city, parents, 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 all this research, I didn’t find anything. This table will have more inserts with different users (always 1 id for each user) but I only exemplified to understand.

Answer 1

I can’t open the link presented by Motta, but must be quoting the function MAX(). Just completing the query would look like this:

SELECT max(data), id, nome, cidade, pais, endereco
FROM tabela
GROUP BY id, nome, cidade, pais, endereco
ORDER BY id

For the other fields of the table, it is necessary to add each of them both in the SELECT how much in part GROUP BY.

Answer 2

The query below solves your problem only replace tabela by your table name

SELECT t1.*
FROM tabela t1
WHERE t1.data = (SELECT MAX(t2.data)
FROM tabela t2
WHERE t2.nome = t1.nome)

Table used for testing

Outcome of the consultation