So simple, yet wonderful:-) Re: New Group By, order by question

Thanks to everyone who Helped, Regards Marty - Original Message - From: "Joseph Bueno" <[EMAIL PROTECTED]> To: "Martin Moss" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 3:56 PM Subject: Re: New Group By, order by quest

Re: New Group By, order by question

select order by abs(field) desc; Hope this helps, Joseph Bueno Martin Moss wrote: All, I have a question about grouping numbers. Lets say I have 10 records each containing a numeric value:- 1 2 3 5 10 -1 -2 -3 -4 -5 What I wish to do is to select the records from the database but group the

Re: New Group By, order by question

Hi Martin, I understand the ABS() function is used for this. Best regards Nils Valentin Tokyo/Japan 2003年 7月 24日 木曜日 23:42、Martin Moss さんは書きました: > All, > > I have a question about grouping numbers. > > Lets say I have 10 records each containing a numeric value:- > > 1 > 2 > 3 > 5 > 10 > -1 > -

New Group By, order by question

All, I have a question about grouping numbers. Lets say I have 10 records each containing a numeric value:- 1 2 3 5 10 -1 -2 -3 -4 -5 What I wish to do is to select the records from the database but group them like this :- e.g. by the highest value (ASC or DESC) regarldess of whether the value