Re: Need SQL guru's help: Best query?

Donna,
Try:
select kit_number, min(model_number)
from motor_table
group by kit_number;

I suppose you could use max() as well.

Good Luck,

Mark Nielsen
Consultant

Donna Kray (kray.donna_at_mlink.motors.ge.com) wrote:
: I have the table
 

: MOTOR_TABLE
: ============================
 

: MODEL_NUMBER KIT_NUMBER
: ------------- ------------
: A 7
: B 7
: C 4
: D 5
: E 7
: F 5
: G 5
: H 4

: MODEL_NUMBER is the primary key for the table. The kits can be used by
: one or more models.
 

: I need a query to return distinct KIT_NUMBER values with one (any one)
: MODEL_NUMBER. E.g.
 

: KIT_NUMBER MODEL_NUMBER
: ----------- ------------
: 4 H (could be C as well)
: 5 D (could be F or G as well)
: 7 E (could be A or B as well)
 

: I don't care which MODEL_NUMBER is returned with the KIT_NUMBER!! Just so
: *every* KIT_NUMBER has an example MODEL_NUMBER.
 

: How do I get this result?
 

: TIA,
: DL Kray
: kray.donna_at_mlink.motors.ge.com
Received on Sun Mar 24 1996 - 00:00:00 CET