/SQL/Select even number id data from table

Select even number id data from table

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

Source: stackoverflow.com

Similar codes

0 vote366 views1 answer
Plpgsql create function
SQL
10 votes299 views5 answers
Mysql create user
SQL
28 votes294 views4 answers
Show tables mysql
SQL
1 vote296 views1 answer
Query for all indexes in table postgres
SQL
8 votes306 views1 answer
How to check mysql version in xampp
SQL
11 votes309 views2 answers
Mysql set safe mode off
SQL
0 vote291 views1 answer
Partitioning in oracle-base
SQL
0 vote277 views1 answer
Clone table structure mysql
SQL
1 vote315 views2 answers
Sql server find all foreign keys that reference a column
SQL
5 votes317 views1 answer
Sql add column after another
SQL