Re: a JOIN on same table, but 'slided over'

["hubert depesz lubaczewski" <depesz@xxxxxxxxx>]

On 6/26/07, Rafal Pietrak <rafal@xxxxxxxxxxxxxxxxxx> wrote:

Is there an SQL construct to get it?

select
    distinct on (t1.id)
    t1.*, t2.*
from
    test t1
    join test t2 on t2.id > t1.id
order by t1.id asc, t2.id asc

should do the trick.

depesz

-- 
http://www.depesz.com/ - nowy, lepszy depesz