Hello all,
I think u guys have mistaken my question,..
The questiion is How will capture the entries which are entered more than
once...
Like
For example
>>
>> Item table
>>
>> Mango
>> Orange
>> Carrot
>> Papaya
>> Mango
>> Mango
I want to capture only mango cos it is repeated more than once
----- Original Message -----
From: "Hal Wigoda" <hwigoda@stripped>
To: "Renish" <koshy.renish@stripped>
Sent: Tuesday, November 28, 2006 11:11 AM
Subject: Re: Simple doubt
> select unique
>
> On Nov 27, 2006, at 8:45 PM, 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
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
>> unsub=hwigoda@stripped
>>
>
