Re: Simple doubt

2006-11-28 Thread Peter Bradley
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 sec

Re: Simple doubt

2006-11-28 Thread Peter Brawley
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]>; Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple

Re: Simple doubt

2006-11-27 Thread Renish
How abt to return the distinct rows? - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt >But if I do like this.. >select dist

Re: Simple doubt

2006-11-27 Thread Peter Brawley
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

Re: Simple doubt

2006-11-27 Thread Renish
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: Sent: Tuesday, November 28, 2006 11:58 AM Subj

Re: Simple doubt

2006-11-27 Thread ViSolve DB Team
D]> Cc: 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

Re: Simple doubt

2006-11-27 Thread Renish
Dupes - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt >But if I do like this.. >select distinct store, price from Item >wi

Re: Simple doubt

2006-11-27 Thread Peter Brawley
om 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: Sent: Tuesday, November 28, 2006 11:18 AM Sub

Re: Simple doubt

2006-11-27 Thread Renish
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 whic

Re: Simple doubt

2006-11-27 Thread Renish
ECTED]> Cc: 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

Re: Simple doubt

2006-11-27 Thread Peter Brawley
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

Simple doubt

2006-11-27 Thread Renish
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/[EMAI