Finding the "most recent" rows

Поиск
Список
Период
Сортировка
От Julian Scarfe
Тема Finding the "most recent" rows
Дата
Msg-id 371F2ED6.29FD9251@scigen.co.uk
обсуждение исходный текст
Ответы Re: [SQL] Finding the "most recent" rows
Список pgsql-sql
I have a table (representing a set of observations) with datetime fields and a
non-unique place field.

e.g.
create table obs (
the_time datetime,
the_place char(8),
...other fields...
)

I'd like an efficient way to pull out the most recent row (i.e. highest
datatime) belonging to *each* of a number of places selected by a simple
query.

e.g. given a table such as:

the_time    the_place    ...
0910        London
1130        London
0910        Paris
0930        London
0840        Paris
1020        London
0740        Paris

I'd like to select:
1130        London
0910        Paris

Most of my attempts at this (as an SQL novice) feel very clumsy and
inefficient. Is there an efficient way of doing this in SQL?
-- 

Julian Scarfe


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bill Carlson
Дата:
Сообщение: UNION with grouping?
Следующее
От: "Justin Long"
Дата:
Сообщение: SELECT TOP _x_ ??