Reduce data returned by a query

If I have a query such as :

SELECT mycolumn FROM mytable;

...which returns eight rows like so:

"One"
"Two"
"Three"
"Four"
"Five"
"Six"
"Seven"
"Eight"

Is it possible to return only every OTHER row? So that only the odd numbered rows are returned like so:

"One"
"Three"
"Five"
"Seven"

I know I can just get rid of my data after the query but then I'm wasting the DB access time getting data I dont want.

Many thanks,

elziko Received on Fri Jan 24 2003 - 04:21:42 CST