Classic ASP Discussion

Print Page | Close Window

Top 5

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=2553
Printed Date: 29 March 2026 at 7:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Top 5

Posted By: Mart
Subject: Top 5
Date Posted: 09 May 2003 at 9:24am

Hi, I want to pull out 5 records out from tblMP3 where tblMP3.popularity is the greatist, how do I only pick out 5?

Replies:

Posted By: ultramods
Date Posted: 09 May 2003 at 9:48am

SELECT TOP 5 * FROM tblMP3 ORDER BY
tblMP3.popularity DESC