How abt to return the distinct rows?
----- Original Message -----
From: "Peter Brawley" <peter.brawley@stripped>
To: "Renish" <koshy.renish@stripped>; <mysql@stripped>
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
> >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
>
