/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 vote213 views1 answer
Stop psql server windows
SQL
18 votes242 views3 answers
Get the list of all tables in sql server
SQL
0 vote260 views1 answer
Sql cursor example multiple columns
SQL
1 vote244 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote225 views2 answers
Get all index postgres
SQL
0 vote216 views6 answers
Unique key in sql
SQL
0 vote229 views1 answer
Sql bild in function
SQL
1 vote216 views1 answer
Check message id sql server
SQL
10 votes251 views4 answers
SELECT FROM WHERE
SQL
0 vote257 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL