Re: Selecting every other code.... why wont THIS work?

Try:

SELECT i.testtime, MOD(i.myrownum,2) FROM (select testtime, rownum myrownum from testdata) i where MOD(i.myrownum,2) = 1;

Daniel Received on Mon Feb 03 2003 - 09:57:48 CST