List:General Discussion« Previous MessageNext Message »
From:Martin Rytz Date:January 27 2005 2:20pm
Subject:How to select every second record
View as plain text  
Hi SQL-Users
 
Is it possible to select only every second record from a record set?
 
I should select the record-number 1, 3, 5, 7, 9, ... or record-number 2, 4,
6, 8, ...
 
Can this be done with LIMIT?
 
Thank you!
 
Greetings, Martin
 
 

Thread
How to select every second recordMartin Rytz27 Jan
  • Re: How to select every second recordMartijn Tonies27 Jan
RE: How to select every second recordJay Blanchard27 Jan
RE: How to select every second recordJay Blanchard27 Jan
  • RE: How to select every second recordGordon27 Jan
RE: How to select every second recordJay Blanchard27 Jan