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

User · Answer

Try this  SELECT DISTINCT city FROM STATION WHERE ID 2 0 ORDER BY CITY

User · Answer

SELECT   FROM Orders where OrderID   2   0    this is for even numbers  SELECT   FROM Orders where OrderID   2    0    this is for odd numbers

User · Answer

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

User · Answer

--This is for oracle  SELECT DISTINCT City FROM Station WHERE MOD Id 2    0 ORDER BY City

User · Answer

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

User · Answer

SELECT   FROM   SELECT    Row Number    OVER ORDER BY country gid  AS sdfg  FROM eka mst tcountry   t  WHERE t country gid   2   0

User · Answer

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

[sql] Select Rows with id having even number

Examples related to sql

Examples related to sql-server

Examples related to sql-function