>But if I do like this..
>select distinct store, price from Item
>will both become distinct?
SELECT DISTINCT returns one result row per distinct _result_ row (which
will be the same as 'per distinct table row' only if all table columns
are selected).
>The questiion is How will capture the entries
>which are entered more than once...
The set of repeated result rows is the set of result rows discarded by
SELECT DISTINCT. Which do you want to return, the distinct rows, or the
dupes?
PB
Renish wrote:
>
> 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
>>
>
>
--
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
