List:General Discussion« Previous MessageNext Message »
From:Renish Date:November 28 2006 3:57am
Subject:Re: Simple doubt
View as plain text  
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
>>
> 

Thread
Simple doubtRenish28 Nov
  • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtRenish28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov
  • Re: Simple doubtViSolve DB Team28 Nov
    • Re: Simple doubtPeter Bradley28 Nov
  • Re: Simple doubtRenish28 Nov
  • Re: Simple doubtRenish28 Nov
    • Re: Simple doubtPeter Brawley28 Nov