/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 vote79 views1 answer
Mysql date + 1 day
SQL
0 vote130 views2 answers
Connect to mysql server mac terminal
SQL
6 votes100 views1 answer
Postgresql add enum value
SQL
0 vote135 views1 answer
Why do we need data structure in sql
SQL
0 vote109 views1 answer
Assign value to var in SQL
SQL
-1 vote109 views1 answer
Mysql case when multiple conditions
SQL
2 votes130 views3 answers
Current setting postgres timezone
SQL
0 vote106 views1 answer
Sql random decimal
SQL
1 vote120 views2 answers
How to check if sql query is correct online
SQL
0 vote99 views1 answer
Postgres create database if not exists
SQL