I really don't want to do this client side (I'd have to execute
approximately 10 queries for every page load just for this small task).
Selecting the entire table into a temp table to number the rows also
seems rather inefficient. I was reading in a book at Barnes and Noble
yesterday which said to
-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 22, 2002 10:41 AM
To: SpamSucks86
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Return every Nth row in a result set
Hello.
On Sun 2002-12-22 at 08:56:43 -0500, [EMAIL PROTECTED] wrote:
I really don't want to do
What would be the SQL query to return every Nth row in a result set? So
it would return the 5th row, the 10th row, the 15th row, etc. Thanks for
any and all replies!
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
appreciative! Thanks.
