/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 vote278 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote239 views1 answer
How to get n result in sql
SQL
0 vote261 views1 answer
Sql server set complex constraints
SQL
0 vote257 views2 answers
Android sqlite query join
SQL
0 vote201 views1 answer
Mitigation of sql injection
SQL
4 votes244 views1 answer
Mysql insert from local csv
SQL
0 vote287 views1 answer
Sql basic commands
SQL
0 vote257 views1 answer
Addition of 2 column value in mysql
SQL
0 vote251 views1 answer
MySQL import data from large CSV file
SQL
0 vote264 views1 answer
Sql commands in android
SQL