/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 vote178 views2 answers
Get all index postgres
SQL
0 vote200 views1 answer
How to combine rows in sql server procedure
SQL
-1 vote270 views5 answers
Left join
SQL
0 vote186 views3 answers
Database restoring error
SQL
0 vote182 views1 answer
How to check even or odd in sql
SQL
1 vote189 views3 answers
Update from select sqlite
SQL
0 vote173 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote185 views1 answer
Oracle search in date columns
SQL
2 votes250 views1 answer
Creating a view SQL
SQL
0 vote191 views1 answer
Exectuer myssql .sql
SQL