Select Rows with id having even number

You are not using Oracle, so you should be using the modulus operator:

SELECT * FROM Orders where OrderID % 2 = 0;

The MOD() function exists in Oracle, which is the source of your confusion.

Have a look at this SO question which discusses your problem.

sql sql-server sql-function

SELECT * FROM Orders where OrderID % 2 = 0;///this is for even numbersSELECT * FROM Orders where OrderID % 2 != 0;///this is for odd numbers

sql sql-server sql-function

MOD() function exists in both Oracle and MySQL, but not in SQL Server.

In SQL Server, try this:

 SELECT * FROM Orders where OrderID % 2 = 0;

CodeHunter