/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

2 votes187 views1 answer
Mysql last 7 days including today
SQL
1 vote177 views1 answer
Mysql return if it contains
SQL
0 vote195 views1 answer
Nvl2 syntax
SQL
4 votes172 views2 answers
DB::transaction
SQL
3 votes186 views1 answer
Oracle revoke grant
SQL
6 votes171 views3 answers
Mysql first day of year
SQL
0 vote181 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote172 views1 answer
Sql create text column limited values
SQL
1 vote177 views1 answer
Select not matching data from two tables
SQL
3 votes185 views1 answer
Oracle user privileges
SQL