/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 vote227 views1 answer
Mysql get hour from datetime
SQL
3 votes220 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote207 views1 answer
Get who is hired in month in sql
SQL
0 vote215 views1 answer
Foreign key type uniqu mysql
SQL
0 vote205 views1 answer
Sql waitfor
SQL
11 votes202 views2 answers
MySQL DISTINCT
SQL
0 vote253 views1 answer
How to check foreign key constraint in sql
SQL
0 vote194 views1 answer
Flask sqlalchemy update row
SQL
0 vote192 views2 answers
Cascade syntax in sql
SQL
1 vote221 views2 answers
Mysql switch case
SQL