select ename,job from(select mod(rownum,2) as odd,ename,job from emp) where odd=1; odd rows are retrive for even just replace as odd=0; keep smiling(pavankumar_cherukuri@yahoo.com)
Your answer for even number query is wrong. The correct query is
SELECT temp.r, employee_id, first_name, last_name
FROM (SELECT rownum as r, employee_id, first_name, last_name FROM employees) temp
WHERE MOD(r,2) = 0;
Write a query to display alternate records from the employee table?
Questions by kowmudiswarna answers by kowmudiswarna
Related Answered Questions
Related Open Questions