/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

2 votes193 views1 answer
Mysql last 7 days including today
SQL
16 votes183 views2 answers
Gremove folder from git
SQL
0 vote227 views1 answer
How to find date from date table in sql
SQL
0 vote193 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote195 views1 answer
Tsql cmd exec script from file
SQL
6 votes273 views1 answer
How to count number of rows in sql
SQL
11 votes231 views1 answer
Oracle view source
SQL
3 votes174 views1 answer
Oracle nextval
SQL
0 vote201 views1 answer
Create table with float datatype in sql server
SQL
5 votes176 views1 answer
Sql asynchronous stored procedure call
SQL