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 по дате отправления: