/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

9 votes215 views3 answers
Oracle undo usage by session
SQL
0 vote208 views1 answer
Alter precision
SQL
0 vote213 views1 answer
RowDataPacket
SQL
0 vote217 views1 answer
Oracle synonym procedure dblink
SQL
0 vote222 views1 answer
Edit a field mysql terminal
SQL
0 vote218 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote221 views1 answer
Mysql backup skip table
SQL
0 vote207 views1 answer
Mysql query single row
SQL
16 votes231 views1 answer
Mysql reset auto increment value
SQL
0 vote220 views1 answer
Mysql set boolean default value
SQL