/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

18 votes105 views3 answers
Find column name in database
SQL
0 vote94 views1 answer
Min and max salary and name in sql
SQL
0 vote101 views2 answers
Pop sql insert value into
SQL
1 vote97 views1 answer
Sql server select rows by distinct column
SQL
1 vote99 views1 answer
Select count distinct multiple columns sql server
SQL
2 votes100 views3 answers
Sql server reseed identity column
SQL
0 vote96 views1 answer
Dump only schema
SQL
5 votes94 views1 answer
Sql first day of current year
SQL
1 vote111 views1 answer
Convert epoch to date in sql server
SQL
0 vote129 views2 answers
Wordpress change url after migration mysql query
SQL