/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 vote195 views1 answer
Get current date data in mysql
SQL
1 vote199 views2 answers
Foreign key set 0
SQL
0 vote197 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote247 views1 answer
Set open file limit mac catalina mysql
SQL
-1 vote201 views3 answers
How to restart mysql in linux
SQL
0 vote206 views1 answer
Como hacer una consulta en sql
SQL
0 vote220 views1 answer
Reset postgres table index to next max value
SQL
1 vote191 views1 answer
Postgresql define pk sequence next number
SQL
0 vote181 views1 answer
Mysql use password error
SQL
0 vote215 views1 answer
How to get data from 2 database
SQL