List:General Discussion« Previous MessageNext Message »
From:Renish Date:November 28 2006 3:23am
Subject:Re: Simple doubt
View as plain text  
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" <peter.brawley@stripped>
To: "Renish" <koshy.renish@stripped>
Cc: <mysql@stripped>
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
> 

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