From: smoshiro@hotmail.com (Sergio Oshiro)
Subject: Min and Max
Date: 29 Nov 2002 10:55:54 -0800
Organization: http://groups.google.com/
Lines: 45
Message-ID: <18210f93.0211291055.6831ae6d@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
To: pgsql-sql@postgresql.org

Hello, everybody!

I've trouble to make a "simple"(?) query...

The following table is an example:

table: children
id_father | child_name | child_age
----------+------------+------------
        1 | John       | 2
        1 | Joe        | 3
        1 | Mary       | 4
        1 | Cristine   | 4
        2 | Paul       | 1
        2 | Stephany   | 2
        2 | Raul       | 5

How can I get the rows of the children name and its "father" such that
they have the min child_ages? I expect the following rows as result:

id_father | child_name | child_age
----------+------------+------------
        1 | John       | 2
        2 | Paul       | 1

The same for the max child_ages...

id_father | child_name | child_age
----------+------------+------------
        1 | Mary       | 4
        1 | Cristine   | 4
        2 | Raul       | 5

I tried to use min() and max() with group by but I could not get the
expected results:

-- 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;


Any suggestions?

Thanks In Advance,
Sergio Oshiro