HI

Select rownum empno ename salary from emp group by rownum empno ename salary having Mod(rownum 2) 0 -- Todisplay EVEN records.

Select rownum empno ename salary from emp group by rownum empno ename salary having Mod(rownum 2) 1 -- Todisplay ODD records.

Note : Here u should group all the columns those are in select statement. Here it is rownum empno ename salary etc.

Please feel free to for any queiries

Thanks

Murali.

select r from
(
SELECT rownum r FROM EMP
)

where mod(r 2) ! 0

We can use the below query to get the even record of the table --

select r from
(
SELECT rownum r FROM EMP
)

where mod(r 2) 0

FOR Even number of records:
select * from emp where (rowid 0) in (select rowid mod(rownum 2) from emp);

try.........................