query help
From: Tao <gordon_t_wu_at_yahoo.com>
Date: 23 Jul 2004 18:37:52 -0700
Message-ID: <5db74e62.0407231737.36c7003_at_posting.google.com>
Hi SQL Masters,
Date: 23 Jul 2004 18:37:52 -0700
Message-ID: <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 - 03:37:52 CEST