Sorry, but I never thought. I'm developing this on my server I'm developing it for someone else who wants it in a WordPress / MySQL environment (I don't know MySQL).
Would this or something similar work in mysql? (Sorry for going O.T.) On Thursday 25 July 2013 19:53:06 Marc Mamin wrote: > >________________________________________ > >Von: pgsql-sql-ow...@postgresql.org [pgsql-sql-ow...@postgresql.org]" > > im Auftrag von "Venky >Kandaswamy [ve...@adchemy.com] > > > >You can use Postgres WINDOW functions for this in several different ways. > > For example, one way of doing it: > > > >select stts_id, last_value(stts_offset) over (partition by stts_id order > > by stts_offset desc) + last_value(stts_duration) over (partition by > > stts_id order by stts_offset desc) from table > >group by stts_id; > > another simple solution with distinct on: > > select distinct on (stts_id, stts_offset) stts_id, > stts_offset+stts_duration from table > order by stts_id, stts_offset desc > > Marc Mamin > -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
