Sql Syntax

Results 1 to 2 of 2

Thread: Sql Syntax

  1. #1
    Marie Guest

    Default Sql Syntax

    I&#039;m displaying 10records at a time. How do i retrieve the next 10 records in a sQl database. I will will hvae like a "Previous 10, Next 10" button. <BR><BR>Also, I&#039;m making a most hits link, i just want to display the first 50 records...yet again, i know not the syntax...<BR><BR>thanks..

  2. #2
    Eddie Campbell Guest

    Default RE: Sql Syntax

    1) Search the FAQs for Paging. There is loads of info available<BR><BR>2) Use TOP in your Sql. E.g. "Select TOP 50 * from MyTable Order By NumberOfHits Desc"

Posting Permissions

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