Select Nth row
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:
You would think there would be an easy way to select the nth row, I did some Googling and got all kinds of answers.
SELECT * FROM Comic WHERE Visible = 1 ORDER BY DatePublished
Read up on 'LIMIT'
LIMIT m,n -> return 'n' rows beginning at row 'm'
Thanks a bunch. That did it.
The embarassing thing is that I have used LIMIT before.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread