I have a table (representing a set of observations) with datetime fields and a
non-unique place field.
create table obs (
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
e.g. given a table such as:
the_time the_place ...
I'd like to select:
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?
pgsql-sql by date
|Next:||From: Justin Long||Date: 1999-04-22 14:33:02|
|Subject: SELECT TOP _x_ ??|
|Previous:||From: Bill Carlson||Date: 1999-04-22 14:05:59|
|Subject: UNION with grouping?|