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

jstrange_at_imtn.dsccc.com (John Strange) wrote:
>column model format a5
>SELECT min(kit_number) kit, model_number model
>FROM moter_table
>group by model_number
>/

You mean:

select min( model_number), kit_number from motor_table

   group by kit_number;

??

Strange's query returns all rows in the table since model_number is the primary key, hence unique.

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

 MODEL_NUMBER KIT_NUMBER
>:> ------------- ------------
>:> A 7
>:> B 7
>:> C 4
>:> D 5

.

>:> I need a query to return distinct KIT_NUMBER values with one (any one)
>

-Austin Received on Tue Mar 26 1996 - 00:00:00 CET