CODE EXAMPLE FOR SQL

odd record sql query

SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=0;