Re: Need SQL guru's help: Best query?
From: Shankar Ramanathan <srnathan_at_amoco.com>
Date: 1996/03/22
Message-ID: <31532CF8.75C5_at_amoco.com>#1/1
Donna Kray 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 Fri Mar 22 1996 - 00:00:00 CET
Date: 1996/03/22
Message-ID: <31532CF8.75C5_at_amoco.com>#1/1
try
select max(model_number), kit_number from table x
group by kit_number;
Donna Kray 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 Fri Mar 22 1996 - 00:00:00 CET