/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 vote251 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote189 views1 answer
Sqlite update where exists
SQL
0 vote150 views1 answer
Vbscript connect mssql
SQL
0 vote147 views1 answer
MySQL error code 2068
SQL
0 vote177 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote143 views1 answer
Json_remove mysql
SQL
0 vote149 views1 answer
Use between operator in mysql
SQL
3 votes160 views1 answer
Oracle revoke
SQL
0 vote162 views1 answer
Query to remove duplicate rows from a table
SQL
6 votes241 views3 answers
Psql show columns of table
SQL