/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 vote297 views1 answer
Mysql sleep connections
SQL
2 votes320 views1 answer
Oracle find unusable indexes
SQL
0 vote330 views1 answer
Sql server set complex constraints
SQL
0 vote333 views1 answer
How to use group_concat in sql server
SQL
0 vote378 views1 answer
How to find unique element in sql
SQL
0 vote309 views1 answer
Mysql update sum same table
SQL
0 vote351 views2 answers
Sql day from datetime
SQL
8 votes345 views1 answer
Sql remove leading spaces
SQL
0 vote333 views1 answer
How to change null display in psql
SQL
9 votes313 views6 answers
Sql insert into
SQL