Records can be fetched for both Odd and Even row numbers -.
To display even numbers-.
|
1
|
SelectstudentIdfrom(Selectrowno,studentIdfromstudent)wheremod(rowno,2)=0
|
o display odd numbers-.
|
1
|
SelectstudentIdfrom(Selectrowno,studentIdfromstudent)wheremod(rowno,2)=1
|
from (Select rowno, studentId from student) where mod(rowno,2)=1.[/sql]