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 demo_table1.bb_id = ds.did and demo_table1.dt_stamp = ds.ts;
Yep, so you used the self-join method. That works, though it's probably quite a lot slower than using a window function for the job. I'm glad you found a suitable solution for your needs. -- Craig Ringer
