/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 vote114 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
2 votes116 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
25 votes140 views1 answer
How to update an attribute in MySQL
SQL
0 vote111 views1 answer
Check sql database table lock
SQL
0 vote124 views1 answer
Query by column for substring sql
SQL
4 votes118 views1 answer
Phone number sql
SQL
0 vote124 views1 answer
Replace \n sql
SQL
0 vote132 views1 answer
Sql cmd no truncate
SQL
0 vote132 views1 answer
Delet all record statment sql
SQL
0 vote114 views1 answer
Postgres week number
SQL