/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 vote136 views1 answer
Check index sql server
SQL
0 vote143 views1 answer
Conda install pymysql "windows"
SQL
1 vote141 views4 answers
Psql check tables command
SQL
0 vote132 views3 answers
Remove folders from remote git
SQL
0 vote169 views1 answer
Pl sql search in all packages
SQL
0 vote133 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
9 votes136 views4 answers
SQL Date Format
SQL
0 vote181 views1 answer
Gcloud sql instance list
SQL
1 vote108 views1 answer
Unique vs distinct sql
SQL
0 vote135 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL