/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

2 votes154 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote164 views1 answer
Window function to forward fill
SQL
0 vote163 views1 answer
Mysql reset wp_options
SQL
0 vote193 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote149 views1 answer
Sql select all from one table and one column from another
SQL
0 vote158 views1 answer
Multiple tricky query in sql server
SQL
6 votes171 views3 answers
Create database mysql utf8
SQL
9 votes200 views1 answer
No sql
SQL
2 votes173 views1 answer
Removing view
SQL
2 votes140 views1 answer
Oracle create directory
SQL