/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

8 votes200 views3 answers
Alter user root mysql
SQL
0 vote291 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote229 views1 answer
Postgres left join
SQL
0 vote209 views1 answer
List all indexes postgres
SQL
0 vote229 views1 answer
Mysql insert into select transaction c#
SQL
0 vote217 views1 answer
Sql mod even odd
SQL
0 vote276 views1 answer
Sql select merge multiple values
SQL
0 vote242 views1 answer
Transaction and commit trong sql server
SQL
1 vote247 views1 answer
Key validation sql
SQL
5 votes206 views2 answers
Oracle timestamp to date
SQL