Write a SQL query to display alternate records from a table?

SELECT *
FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)
WHERE rn =0;

For odd rows:

SELECT *
FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)
WHERE rn =1;