/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 vote285 views1 answer
Sql show all users
SQL
3 votes274 views3 answers
Mysql get table size
SQL
19 votes305 views6 answers
Mysql if null
SQL
0 vote331 views1 answer
Wordpress make wp user in db
SQL
0 vote286 views3 answers
Insert or ignore postgres
SQL
1 vote335 views2 answers
Laravel jwt generate token
SQL
0 vote306 views1 answer
Postgresql replace html tags from string
SQL
0 vote245 views1 answer
Jooq finding lastest value in table
SQL
0 vote318 views1 answer
Having all mysql
SQL
0 vote296 views1 answer
Exectuer myssql .sql
SQL