SELECT DISTINCT RECENT VALUE FROM DB

Question

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

Have you taken a look at `GROUP BY` – Achrome Jun 14 '13 at 10:40 — Achrome, Jun 14 '13 at 10:40

juergen d · Accepted Answer · 2013-06-14T10:52:14.190

3

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

edited Jun 14 '13 at 10:52

answered Jun 14 '13 at 10:40

juergen d

score 1 · Answer 2 · answered Jun 14 '13 at 10:43

1

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

answered Jun 14 '13 at 10:43

Jayram

1

You can't mix aggregate functions and normal column selects without a group. – juergen d Jun 14 '13 at 10:46
Yes, but how does it differ from my answer I gave 7 minutes ago? – juergen d Jun 14 '13 at 10:49

2 Answers2