Re: Select f1, min(f2) ????
From: InfoAd - Jurrian Beuker <infoad_at_xs4all.nl>
Date: 1996/05/13
Message-ID: <4n6id4$260_at_news.xs4all.nl>#1/1
Date: 1996/05/13
Message-ID: <4n6id4$260_at_news.xs4all.nl>#1/1
Konstantin Kivi <kivi_at_glas.apc.org> wrote:
>select f1, f2 from t1 where f2=min( select f2 from t1
> where (<<criteria>>));
>For simplicity lets assume that all f2 are different.
select f1,f2
from t1
where f2= (select min(f2)
from t1
where <criteria1>)
and <criteria2>;
>Konstanti
Received on Mon May 13 1996 - 00:00:00 CEST