To find dupe rows in tbl on cols a,b,c,d,e:
SELECT a,b,c,d,e
FROM tbl
GROUP BY a,b,c,d,e
HAVING COUNT(*) > 1;
PB
-----
Renish wrote:
> Dupes
> ----- 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
>>
>
>
>
--
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
