www.webdeveloper.com
Results 1 to 3 of 3

Thread: Select Nth row

  1. #1
    Join Date
    Jan 2009
    Posts
    24

    Select Nth row

    Hi there,

    I am looking for some help selecting the Nth row for a particular query.

    I want to select the Nth row for a query that looks similar to this:

    Code:
    SELECT * FROM Comic WHERE Visible = 1 ORDER BY DatePublished
    You would think there would be an easy way to select the nth row, I did some Googling and got all kinds of answers.

  2. #2
    Join Date
    Dec 2002
    Location
    Pleasanton, CA
    Posts
    2,132
    Read up on 'LIMIT'
    LIMIT m,n -> return 'n' rows beginning at row 'm'

  3. #3
    Join Date
    Jan 2009
    Posts
    24
    Thanks a bunch. That did it.

    The embarassing thing is that I have used LIMIT before.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



Recent Articles