But if I do like this..
select distinct store, price from Item
will both become distinct?
How can I make only one distinct ie "store" distinct
regards,
----- Original Message -----
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Tuesday, November 28, 2006 11:18 AM
Subject: Re: Simple doubt
SELECT DISTINCT ...
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
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date:
11/27/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
