Select Rows with id having even number

Question

I'm passing a straightforward query that looks for particular rows where OrderID is an even number.

SELECT * 
FROM Orders 
WHERE mod(OrderID,2) = 0;

Error :

Syntax error (missing operator) in query expression 'mod(OrderID,2) = 0'.

Can someone please help me solve this? 

Answer 1

Use the modulus operator:

SELECT * FROM Orders where OrderID % 2 = 0;

The MOD() function exists in Oracle, which is the source of your confusion. I hope this helps you.

Answer 2

Try this one,

SELECT * 
FROM Orders

WHERE Orders%2=0