/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 vote298 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
4 votes283 views2 answers
Mysql alter table set column unique
SQL
0 vote187 views1 answer
Oracle create package body
SQL
1 vote198 views1 answer
How to see logical reads in sql server
SQL
0 vote148 views1 answer
Mysqli or pdo
SQL
9 votes218 views6 answers
Oracle substring
SQL
0 vote207 views1 answer
Mysql return column names when table is empty
SQL
0 vote199 views1 answer
Oracle select partition
SQL
0 vote200 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote204 views1 answer
Drop all procedures sql server
SQL