/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

4 votes351 views3 answers
Mysql update with join
SQL
1 vote345 views1 answer
Display total number of tables in mysql
SQL
1 vote375 views2 answers
Find nth highest salary of an employee
SQL
0 vote389 views1 answer
Mysql record group by created date count
SQL
0 vote365 views1 answer
Vowels in sql
SQL
0 vote383 views1 answer
Postgres regex word boundary
SQL
0 vote430 views3 answers
Constraint sql
SQL
3 votes368 views1 answer
Oracle list user grants
SQL
1 vote343 views1 answer
Mysql pretty date format
SQL
1 vote359 views1 answer
Postgresql delete cascade
SQL