Select Rows with id having even number

Question

I am passing a simple query where I am searching for specific 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'.

Unfold

Oracle-Server or SQL-Server ?? @solankikaushik – Teague

Doesn't look like T-SQL (MS SQL Server) to me - there's no mod function that I've heard of. OP could do SELECT * FROM Orders WHERE OrderID % 2 = 0 though, I think. – Rilda

@Malik Asif : Sql Server – Unfold

Go to link: Already given answer OR Query is: SELECT * FROM Orders where OrderId % 2 = 0; – Teague

@Rilda : How to perform this query in ms-sql server ? – Unfold

works for me in sql plus server – Attaway

This will work in MySQL – Ambie

Answer 1

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.

Audi

Answer 2

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

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

Ingenuous

Answer 3

Sql Server we can use %

select * from orders where ID % 2 = 0;

This can be used in both Mysql and oracle. It is more affection to use mod function that %.

select * from orders where mod(ID,2) = 0

Rigdon

The question is about SQL Server, not Oracle or MySQL though. – Lenardlenci

Answer 4

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;

Palaeogene

Answer 5

--This is for oracle

SELECT DISTINCT City FROM Station WHERE MOD(Id,2) = 0 ORDER BY City;

Faultless

Answer 6

Try this:

SELECT DISTINCT city FROM STATION WHERE ID%2=0 ORDER BY CITY;

Chatoyant

Answer 7

For SQL Server:

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

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

For Oracle and MySQL, you have to use the MOD function:

select * from orders where mod(ID,2) = 0

Jillene

Answer 8

In SQL, all these options can be used for MOD:

SELECT * FROM CITY WHERE MOD(ID,2) = 0 ORDER BY CITY;

OR

SELECT * FROM CITY WHERE ID % 2 = 0 ORDER BY CITY;

OR

SELECT * FROM CITY WHERE ID MOD 2 = 0 ORDER BY CITY;

Hope it helps!

Okeefe

Answer 9

;With MYCTE(Empid)
As 
(
  SELECT * FROM employeeodd 
)
Select *
From MYCTE
where empid % 2 = 0;

;With MYCTE(Empid)
As 
(
  SELECT * FROM employeeodd 
)
Select *
From MYCTE
where empid % 2! = 0;

Scientism

Your answer could be improved by adding more information on what the code does and how it helps the OP – Efrenefron

Answer 10

SELECT * FROM ( SELECT *, Row_Number() 
OVER(ORDER BY country_gid) AS sdfg  FROM eka_mst_tcountry ) t 
WHERE t.country_gid % 2 = 0 

Ingenuous