/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 vote195 views1 answer
Pl sql constraint user function
SQL
0 vote183 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote227 views1 answer
Install postgresql 12 on debian 10
SQL
2 votes210 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote225 views1 answer
Convert int to varchar sql
SQL
0 vote214 views1 answer
Make parameters nullable in sql server
SQL
0 vote182 views1 answer
Using GROUP BY in MySQL Join Table
SQL
8 votes163 views1 answer
Similarities between ddl and dml
SQL
0 vote179 views1 answer
Where case insensitive like mysql
SQL
0 vote198 views1 answer
Sqlplus change user
SQL