Min and Max
От | smoshiro@hotmail.com (Sergio Oshiro) |
---|---|
Тема | Min and Max |
Дата | |
Msg-id | 18210f93.0211291055.6831ae6d@posting.google.com обсуждение исходный текст |
Ответы |
Re: Min and Max
Re: Min and Max |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: