Thursday 27 April 2017

Alternative Records from the table

SELECT *
FROM (SELECT EMP.*,ROWNUM AB FROM EMP)
WHERE MOD(AB,2)<>0;