Re: query help

From: Michael J. Moore <DoNThicamelSPAM_at_comcast.net>
Date: Sat, 24 Jul 2004 02:54:38 GMT
Message-ID: <ObkMc.173305$XM6.146873_at_attbi_s53>


select el2,min(el3||' '||el1) from test group by el2

where el2 is fieldA and el3 is fieldB and el1 is P_Key

I know there is a better way

"Tao" <gordon_t_wu_at_yahoo.com> wrote in message news:5db74e62.0407231737.36c7003_at_posting.google.com...
> Hi SQL Masters,
>
> I know its probably a simple query, but I've spent a long time on it
> and could not figure it out.
>
>
> I'm trying to select distinct fieldA in the table, such that fieldB
> is smallest within each fieldA. Suppose the table has following rows:
>
> P_Key fieldA fieldB
> 1 1 5
> 2 1 4
> 3 2 4
> 4 2 3
>
> The result of the query would look like:
>
> P_Key fieldA fieldB
> 2 1 4
> 4 2 3
>
> Appreciate your help!
Received on Sat Jul 24 2004 - 04:54:38 CEST

Original text of this message