Re: Min and Max
От | Jean-Luc Lachance |
---|---|
Тема | Re: Min and Max |
Дата | |
Msg-id | 3DEBBA62.CFFE0F34@nsd.ca обсуждение исходный текст |
Ответ на | Re: Min and Max (Dennis Björklund <db@zigo.dhs.org>) |
Список | pgsql-sql |
If you do not mind non standard, how about: SELECT DISTINCT ON(id_father) * FROM children ORDER BY id_father, child_age; Dennis Björklund wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-sql по дате отправления: