/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

8 votes139 views1 answer
Oracle add datafile to tablespace
SQL
0 vote127 views1 answer
How to see password mysql vestacp
SQL
21 votes128 views3 answers
Sql average
SQL
0 vote184 views1 answer
Oracle temporary table
SQL
3 votes130 views1 answer
Only join in sql
SQL
0 vote137 views1 answer
Sql select min row
SQL
-1 vote165 views3 answers
SQL MM/dd/yyyy format
SQL
1 vote130 views1 answer
Mysql get domain from url
SQL
0 vote126 views1 answer
Assign value to var in SQL
SQL
1 vote142 views1 answer
Sql server kill all connections
SQL