Re: query help

here is a better answer

  1 select el1,el2,el3 from test a
  2 where
  3 not exists (select * from test b

  4              where b.el2 = a.el2
  5*             and   b.el3 < a.el3)

EL1                         EL2        EL3
-------------------- ---------- ----------
2                             1          4
4                             2          3

"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 - 05:32:54 CEST