Smart. and simple .I should have thought for a while:-(
----- Original Message -----
From: "ViSolve DB Team" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>; "Hal Wigoda" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
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" <[EMAIL PROTECTED]>
To: "Hal Wigoda" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
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" <[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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
