Answers for "how to find even and odd records in sql server"

how to check even or odd in sql

SELECT * 
FROM table_name 
WHERE mod(column_name,2) = 0;

Posted by: Guest on July-19-2021

odd record sql query

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

Posted by: Guest on September-17-2021

Code answers related to "how to find even and odd records in sql server"