Re: Simple doubt

SELECT DISTINCT a,b,c,d,e FROM tbl; Renish wrote: How abt to return the distinct rows? - 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

Re: Simple doubt

Ysgrifennodd ViSolve DB Team: 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

Simple doubt

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:

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:

Re: Simple doubt

, 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

Re: Simple doubt

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

Re: Simple doubt

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

Re: Simple doubt

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

Re: Simple doubt

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

Re: Simple doubt

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

Re: Simple doubt

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

Re: Simple doubt

How abt to return the distinct rows? - 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