/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 votes271 views2 answers
Sql server date now
SQL
0 vote300 views10 answers
Sql statement checker corrector
SQL
0 vote275 views2 answers
Mysql dump structure only
SQL
0 vote263 views1 answer
Sql server count all tables rows
SQL
1 vote280 views1 answer
T-sql disable system versioning
SQL
0 vote273 views1 answer
Sql get count without group by
SQL
1 vote218 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote268 views1 answer
Alter database name script
SQL
3 votes267 views2 answers
Oracle apex view logs
SQL
3 votes293 views2 answers
Sql add year to date
SQL