/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

16 votes109 views2 answers
Mysql date between two dates
SQL
-1 vote101 views1 answer
How to use update trigger in sql
SQL
1 vote112 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
1 vote106 views1 answer
Primary key with prefix sql
SQL
3 votes131 views1 answer
Define REGEXP?
SQL
0 vote100 views1 answer
Limiting query result using where in sql
SQL
0 vote103 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote106 views2 answers
Mysql two column combination unique
SQL
0 vote107 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
3 votes109 views1 answer
Oracle limit user tablespace
SQL