Re: How can I group all children by their parent ?

From: François Beausoleil <francois(at)teksol(dot)info>
To: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can I group all children by their parent ?
Date: 2014-07-17 13:15:26
Message-ID: 3459F8A3-3A19-4D2D-9532-81465F83031B@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Le 2014-07-17 à 09:08, Arup Rakshit <aruprakshit(at)rocketmail(dot)com> a écrit :

> How can I group all children by their parent ?
>
> id email parent_id
> 1 test(at)test(dot)com nil
> 2 test1(at)test(dot)com 1
> 3 email 1
> 4 email 2
> 5 email nil
> 6 email 3

ORDER BY parent_id, id ?

François Beausoleil

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pujol Mathieu 2014-07-17 13:16:40 Re: How can I group all children by their parent ?
Previous Message Arup Rakshit 2014-07-17 13:08:51 How can I group all children by their parent ?