CODE EXAMPLE FOR SQL

basic sql queries interview questions

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