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


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

Original text of this message