How to chop an ordered (DESC) recordset before sending it to the client ??

Results 1 to 2 of 2

Thread: How to chop an ordered (DESC) recordset before sending it to the client ??

  1. #1
    Lodewijk Wiggers Guest

    Default How to chop an ordered (DESC) recordset before sending it to the client ??

    Hi!<BR>I have looked at the article of retrieving the top N records of some table.<BR>Unfortunately it confused me a lot. Can anybody help me out here ?<BR>The situation is like this:<BR>I want to select the top 10 bestsellers from my books sold...<BR>I start with:<BR>SELECT * FROM BOOKS ORDER BY BOOKS.NR_SOLD DESC;<BR>Now I am stuck, I just want to retrieve the top N, how do I go from here (remember that I want all of the fields from BOOKS in my recordset).<BR>Thanks a lot!<BR>Lo

  2. #2
    Stephen Fisher Guest

    Default RE: How to chop an ordered (DESC) recordset before sending it to the client ??

    Do a search on paging at www.4guysfromrolla.com<BR><BR>They have an example which I am using and it works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •