Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only return X number of records

Status
Not open for further replies.
Scorez2000

Scorez2000

Programmer
Feb 5, 2004
87
GB
I'm writing my own first discussion board in ASP.

I want to run a query to pull out the latest 20 threads. However, There may end up being thousands of threads in the database. Creating a query with 1000s of records will not be very efficient.

Is it possible to order the records by date and then only select the top 20 records to appear in my recordset?

Thanks in advance,
Wayne
 
Sort by date Sort by votes
SELECT TOP 10 table.field, table.field2...."

Easy as that.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Question
Select X of each variation of a field 1
Replies
8
Views
353
rashmibala
R
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
758
JimStrand
JimStrand
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
450
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
569
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top