Re: ORDER BY command

2001-01-16 Thread Jeremy D. Zawodny
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote: > Hello. I am trying to get the results from a query to be ORDERED by > ASCENDING instead of the default DESCENDING. Is this possible, and > if so how? I mis-wrote in my reply (which hasn't come thru the list yet). You can use "ASC" but now

Re: ORDER BY command

2001-01-16 Thread Jeremy D. Zawodny
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote: > Hello. I am trying to get the results from a query to be ORDERED by > ASCENDING instead of the default DESCENDING. Is this possible, and > if so how? As the manual explains: SELECT . ORDER BY foo ASC or SELECT . ORDER B

RE: ORDER BY command

2001-01-16 Thread G r e g L a w r i e
> -Original Message- > From: Robert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 17 January 2001 7:10 > To: [EMAIL PROTECTED] > Subject: ORDER BY command > > > Hello. I am trying to get the results from a query to be ORDERED by > ASCENDING instead of the default D

Re: ORDER BY command

2001-01-16 Thread j.urban
select col1,col2 from table1 order by col1 ASC; Please see the manual: http://www.mysql.com/doc/S/E/SELECT.html On Tue, 16 Jan 2001, Robert wrote: > Hello. I am trying to get the results from a query to be ORDERED by > ASCENDING instead of the default DESCENDING. Is this possible, and if so >

ORDER BY command

2001-01-16 Thread Robert
Hello. I am trying to get the results from a query to be ORDERED by ASCENDING instead of the default DESCENDING. Is this possible, and if so how? Robert - Before posting, please check: http://www.mysql.com/manual.php (the