Re: Select f1, min(f2) ????
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1996/05/21
Message-ID: <4nth9m$2l4_at_homer.alpha.net>#1/1
Date: 1996/05/21
Message-ID: <4nth9m$2l4_at_homer.alpha.net>#1/1
seci_at_ludens.elte.hu wrote:
> Hello,
> In article <4n6hd2$eev_at_castle.nando.net>, blais_at_nando.net (Al Blais) writes:
> >>select f1, f2 from t1 where f2=min( select f2 from t1
> >> where (<<criteria>>));
How about
select substr ( min ( f2 || f1 ), len_of_f2, length_of_f1 )
from t1
where <<>>;
-- ************************************************************** * Saad Ahmad * * Senior Software Engineer * * McHugh Freeman & Associates, Inc. * * Ph: (414) 798-7457 * * Fax: (414) 798-8619 * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Tue May 21 1996 - 00:00:00 CEST