Classic ASP Discussion - select the top 5 data

Print Page | Close Window

select the top 5 data

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6844
Printed Date: 31 March 2026 at 3:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: select the top 5 data

Posted By: brolinuk
Subject: select the top 5 data
Date Posted: 30 October 2003 at 12:12am

Anyboy could tell me how would I be able to select the top 5 data in a certain order from the Access database. For example, I want to display the five most recent data in a time sequence.

Replies:

Posted By: zaboss
Date Posted: 30 October 2003 at 12:24am

Select Top 5 * from YourTable Where YourSQLQuery Order By Date DESC

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web

Posted By: brolinuk
Date Posted: 30 October 2003 at 1:25am

Thanks zaboss

How about list by random order

Posted By: zaboss
Date Posted: 30 October 2003 at 1:48am

I guess you can build a function in which to play with the date and re-order them randomly (a way of speaking as it still would be something logicaly ordered)...

My advice is to let it this way unless realy necesary.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web

Posted By: gupta_ji
Date Posted: 30 October 2003 at 6:54am

i have same question

-------------
http://www.sgrj.com" rel="nofollow - chartered accountants India , http://www.delhiprofessionals.com" rel="nofollow - accounting Outsourcing ISO Certification

Posted By: Badaboem
Date Posted: 30 October 2003 at 7:05am

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6201 - http://www.planet-source-code.com/vb/scripts/ShowCode.asp?ln gWId=4&txtCodeId=6201