/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

0 vote358 views1 answer
Run docker container with database as rds metabase
SQL
1 vote273 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
6 votes294 views3 answers
Mysql remove user privileges
SQL
0 vote265 views1 answer
Login phpmyadmin without password
SQL
1 vote296 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote299 views1 answer
Show specific events on mysql
SQL
1 vote269 views1 answer
Install postgresql on raspberry pi
SQL
0 vote273 views1 answer
Convert .mdf to .bak
SQL
2 votes275 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
22 votes258 views6 answers
Create sql table
SQL