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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
