From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
---|---|
To: | Sergio Oshiro <smoshiro(at)hotmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Min and Max |
Date: | 2002-12-02 18:44:03 |
Message-ID: | Pine.LNX.4.44.0212021939410.9578-100000@zigo.dhs.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 29 Nov 2002, Sergio Oshiro wrote:
> How can I get the rows of the children name and its "father" such that
> they have the min child_ages?
>
> -- the following does not return the child_name...
> select id_father, min(child_age) from children group by id_father;
> select id_father, max(child_age) from children group by id_father;
You could join one of the above with the table itself and get the result.
Something like
select *
from ( select id_father, min(child_age)
from children
group by id_father) as r,
children
where children.id_father = r.id_father
and children.min = r.min;
--
/Dennis
From | Date | Subject | |
---|---|---|---|
Next Message | Casey Allen Shobe | 2002-12-02 18:46:38 | Combining queries while preserving order in SQL - Help! |
Previous Message | Joel Burton | 2002-12-02 18:38:27 | Re: [SQL] CURRENT_TIMSTAMP |