Re: query help
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