/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 votes174 views2 answers
Mysql time
SQL
0 vote208 views1 answer
Get last inserted primary key
SQL
3 votes167 views2 answers
Sql random integer
SQL
3 votes164 views1 answer
Make a field auto_increment mysql
SQL
-1 vote159 views1 answer
Export mysql table to file
SQL
0 vote137 views0 answer
SQL
0 vote176 views1 answer
T sql cursor tr
SQL
2 votes182 views2 answers
Mysql count rows returned
SQL
8 votes181 views2 answers
Oracle auto increment primary key
SQL
5 votes171 views2 answers
Oracle timestamp to date
SQL