On 11/10/11 12:55, Adarsh Sharma wrote:
> Thanks Craig, but I solved the issue by the below query :-
>
> Here is the query for that :-
>
> select bb_id,lat,lon,speed,dt_stamp from demo_table
> inner join
> (select bb_id as did, max(dt_stamp) as ts
> from demo_table group by bb_id) as ds
> on
Thanks Craig, but I solved the issue by the below query :-
Here is the query for that :-
select bb_id,lat,lon,speed,dt_stamp from demo_table
inner join
(select bb_id as did, max(dt_stamp) as ts
from demo_table group by bb_id) as ds
on demo_table1.bb_id = ds.did and demo_table1.dt_stamp = ds.t
Any update on the below query :-
I tried the below query but :-
*
select bb_id,lat,lon,max(dt_stamp) from gps_tracker group by bb_id;
*
ERROR: column "gps_tracker.lat" must appear in the GROUP BY clause or
be used in an aggregate function
LINE 1: select bb_id,lat,lon,max(dt_stamp) from gps_trac
Hi Craig :-
Below is the schema of my table :-
CREATE TABLE demo_table
(
id character varying NOT NULL,
lat double precision,
lon double precision,
speed double precision,
dt_stamp timestamp without time zone DEFAULT now(),
CONSTRAINT gps_tracker_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE)
On 10/10/2011 08:32 PM, Adarsh Sharma wrote:
Dear all,
I need to write a query to select latest rows with timestamp values.
My ID is repeated with lat lon and timestamp. I want the latest row of
each ID ( group by id ).
[snip]
"3911";"661000212";26.8491101532852;92.8058205131302;0;"2011-10-1
