The sql code to find odd number of records is:
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);
But if I do the foll code for odd nos:
select * from student where mod(rownum,2)=1;
Then it displays only the first row!Why is that so because I think the logic is true for odd numbers.Can someone please give solution to this?