How to select every second record

[Martin Rytz]

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