Dupes
----- Original Message -----
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
>But if I do like this..
>select distinct store, price from Item
>will both become distinct?
SELECT DISTINCT returns one result row per distinct _result_ row (which
will be the same as 'per distinct table row' only if all table columns are
selected).
>The questiion is How will capture the entries
>which are entered more than once...
The set of repeated result rows is the set of result rows discarded by
SELECT DISTINCT. Which do you want to return, the distinct rows, or the
dupes?
PB
Renish wrote:
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
--
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]
