从DB中选择DISTINCT近期值[复制]

Question

This question already has an answer here:

• Return the data from the rows with the most recent date of each distinct candidate_id 2 answers

I need to get all distinct value from db according to their recent/last entryModTime.

For your understanding

id entry_modtime

3  13-12-1977
3  14-12-1977
4  13-12-1977
5  13-12-1977 
2  13-12-1977
3  15-12-1977

In the above table id field is not primary. I need get all data from that table so the output should be,

3 15-12-1977
4 13-12-1977
5 13-12-1977
2 13-12-1977

</div>

Answer 1

You can group around your id and select the highest date for every id with max()

select id, max(entry_modtime) as latest_entry_modtime
from your_table
group by id