Smart. and simple .I should have thought for a while:-(
----- Original Message -----
From: "ViSolve DB Team" <mysql_support@stripped>
To: "Renish" <koshy.renish@stripped>; "Hal Wigoda" <hwigoda@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, November 28, 2006 11:58 AM
Subject: Re: Simple doubt
> Hi Renish,
>
> If you want to capture the entries which are entered more than once.
> Here's the answer for it.
>
> mysql> select * from a;
> +--------+
> | b |
> +--------+
> | pen |
> | pencil |
> | rubber |
> | pen |
> | paper |
> | paper |
> +--------+
> 6 rows in set (0.00 sec)
>
> mysql> select b from a group by b having count(b)>1;
> +-------+
> | b |
> +-------+
> | paper |
> | pen |
> +-------+
> 2 rows in set (0.00 sec)
>
> Hope this helps.
>
>
> Thanks,
> ViSolve DB Team.
>
> ----- Original Message -----
> From: "Renish" <koshy.renish@stripped>
> To: "Hal Wigoda" <hwigoda@stripped>
> Cc: <mysql@stripped>
> Sent: Tuesday, November 28, 2006 9:03 AM
> Subject: Re: Simple doubt
>
>
>>
>> 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
>>>>
>>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>
