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" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
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?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]