sql-help
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1144
Printed Date: 28 March 2026 at 4:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: sql-help
Posted By: kobubu
Subject: sql-help
Date Posted: 19 March 2003 at 8:35am
|
somebody can tell me what does it mean "order by order_id desc" it comes from: set maxOrderSet=outpostDB.Execute("select order_id from"_ thank you all |
Replies:
Posted By: zaboss
Date Posted: 19 March 2003 at 9:01am
|
desc come from descendent. It sorts the records in descendent order. if you want the other way arround, put there asc (which comes from ascendent). ------------- Cristian Banu http://www.soft4web.ro - Soft 4 web |
Posted By: WebWiz-Bruce
Date Posted: 19 March 2003 at 9:05am
|
Don't you mean descending and ascending order? ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: kobubu
Date Posted: 19 March 2003 at 9:10am
thank you all
|
Posted By: Morgan
Date Posted: 21 March 2003 at 11:23am
|
From Microsoft's SQL Books Online: ASC Specifies that the values in the specified column should be sorted in ascending order, from lowest value to highest value. DESC Specifies that the values in the specified column should be sorted in descending order, from highest value to lowest value. Null values are treated as the lowest possible values. ------------- Morgan |