/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 vote137 views1 answer
Mysql sum per week
SQL
2 votes124 views1 answer
Oracle cpu per session
SQL
0 vote133 views1 answer
Oracle archivelog usage
SQL
0 vote136 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote143 views1 answer
What is top n result in sql
SQL
2 votes144 views3 answers
Current setting postgres timezone
SQL
1 vote127 views1 answer
Mysql select month and year
SQL
0 vote140 views1 answer
Open postgresql.conf in centos
SQL
0 vote124 views2 answers
Nosqlbooster query other collection
SQL
0 vote127 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL