But if I do like this..
select distinct store, price from Item
will both become distinct?
How can I make only one distinct ie "store" distinct
regards,
----- Original Message -----
From: "Peter Brawley" <peter.brawley@stripped>
To: "Renish" <koshy.renish@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, November 28, 2006 11:18 AM
Subject: Re: Simple doubt
> SELECT DISTINCT ...
>
> Renish wrote:
>> Gurus,
>>
>> How do I go about to selecting an item which is repeated more than one in
>> a field in a table.
>>
>> For example
>>
>> Item table
>>
>> Mango
>> Orange
>> Carrot
>> Papaya
>> Mango
>> Mango
>>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date:
> 11/27/2006
>
